View Full Version : VBA code to create Indented BOM

04-25-2017, 03:46 PM
Hello all,

I am trying to create an indented BOM from a data export.

If you see the attached file 19021 you can see the data format. The "Top Level" number is in column B and the "component number" is in Column E.

So looking at the data any value that exists in column E but also in column B are sub assemblies.

For example part "A" is a top level assemble that contains parts "B-R" however you can see that part "B" is also in in column B with a list of components.

So what I am trying to accomplish is represented in the expected results tab. for any part that exists in both B and E I want to copy up the structure for that part.

Our subs extend out to 6 levels which I have represented in the example.

If anyone can write a code to accomplish this it would be a HUGE help.

I realize this is a big task and complicated and we may need to communicate more on the topic but this should be a start.

See the breakdown of part "A" on the expected results tab for a detail of what I am after.

04-28-2017, 12:43 PM
Your result is not complete and what is shown is inconsistent. Why 3 PI and no PO? The logic is not clear.

04-28-2017, 01:25 PM
Cross posted http://www.ozgrid.com/forum/showthread.php?t=203874