Bom's have Multiple levels

[Mamdouh Elfors]

Hi

I have many BOM’s Finished Goods and many BOM’s Sub-assemblies. I want to fully explode the Sub-assemblies so that only the Finished Goods codes remain, with their lowest-level components.

Note: A BOM’s Sub-assembly can also contain other Sub-assemblies, and this hierarchy may continue multiple levels.

I Attached File For Example

 

[BobBridges]

The only way I know how to do this is to write a recursive program to do the exploding; I don't suppose there's a way to do it using Excel formulae. That means you'll have to ask the question in the VBA forum, at the very least, and probably at least attempt the program yourself to make a start...although sometimes folks are willing to write something from scratch for you.