multi level bom explosions in excel using vba

[@excelhighway3549]

The file is available on my Patreon page:
www.patreon.com/ExcelHighway

[@mohammadalshaboul9569]

Incredible work thank you so much. This basically solves my problem with the last video I believe I watched on your channel on the same topic.

[@excelhighway3549]

Glad it helped!

[@muharremdemircan]

teşekkürler iyi bir çalışma olmuş,

[@excelhighway3549]

Thank you for your feedback

[@kris-y2t]

Excellent!! Thank you!!!

[@excelhighway3549]

Thank you for your feedback

[@feliciantuli1054]

Hi, is there a tutorial anywhere where after I've made a single bom explosion, i can get the total for the raw material for multiple items that i have selected?

[@excelhighway3549]

Do you mean a where used report?

[@feliciantuli1054]

@@excelhighway3549 like from a non explosion let’s say I want 4 prod A and 5 prod B. A report that will show me that you will need 10 comp A and like 7 comp B and so forth

[@ΠαναγιώτηςΠαπαγιαννόπουλος-ω1β]

I get a persistent syntax error on line #9 : lRow = ws.Cells(Rows.Count, col).End(xlUp).row
Could you please advice?

[@excelhighway3549]

Is ws defined properly?

[@joshcosgrove832]

In your example there is a single item in level 2, 3, etc. Would it still work correctly if there were multiple sub assemblies from level 2 and on?

[@excelhighway3549]

Yes, it is setup up to 5 levels.

[@mohammadalshaboul9569]

@@excelhighway3549 I have the same question and I still don't understand how it works. its not levels exactly. it is that level one has 3 sub-assemblies in it (A, B, and C) and Sub-assembly A has 2 sub-sub-assemblies (lets say C and D). This is an example of 3 layers but 5 sub and sub-sub assemblies.

[@excelhighway3549]

@@mohammadalshaboul9569 your example is 3 layers. First layer is the final item (layer 1). It's assembled from A,B,C (layer 2). A is assembled from C,D (layer 3).
FG - A - C.

[@danwill6469]

you need to sort out you sound issues man... you voice is quite and then the pounding from keys is terrible

[@excelhighway3549]

Thanks for the feedback.