lsxtrkiller
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.
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.