Thread:Zonko64/@comment-43596541-20190921071205/@comment-43596541-20190922050654

Send me an e-m ,  when in the COLLECTIONS DETAILS in will become self-evident  ;)  It uses the COLLECTION DETAILS I grab from HC Wiki ...  Eventually I'll put in a "select nox" on top of the form to allow easy cut & paste within the same Tab ... But this version is usable right now ...  I've limited the BOM to 10 Collections out of laziness :)   but you could extend it to whatever pleases you by adding formulas to a name range ... there 4 lines to add per Collection, so if you want to sum up   50 collections instead of 10 then you'd have to cut & paste and edite the 40 x 4 lines to add ...

I did not find the function I am looking for to create the Pivot Table so I went the OLD fashion "Transpose" way:  I copy the assemblers  from col 1 - 4 onto Lines  1 - 4 in a range not shown in the above SS  and use that range as "source" of the Pivot table ... I have to that because Pivot Table "assume"  a Column is  a different field and dont add them together ...

I will eventually write a Macro that does the generation for any number of  Collections by using the Transpose function that  switches : A - B - C -D to   Line1 A, Line2 B, Line3 C,  Line3 D ... But I have to do the Artifacts first ... :)