multi level bom explosions in excel using vba

In today's video I will share an Excel file that you can use to fully explode a bill of material (BOM) no matter how many levels exist. Using a simple VBA code and some clever array functions you can build this file and start exploding your items into components.
The file is available on my Patreon page:
/ excelhighway
------------------------------
Track: Travel With Us - Vendredi [Audio Library Release]
Music provided by Audio Library Plus
Watch: • Travel With Us - Vendr...
Free Download / Stream: alplus.io/trav...

[@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!

[@ΠαναγιώτηςΠαπαγιαννόπουλος-ω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?

[@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

[@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.