-
VBA code to create Indented BOM
Hello all,
I am trying to create an indented BOM from a data export.
If you see the attached file Sample BOM.xlsx 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.
-
Your result is not complete and what is shown is inconsistent. Why 3 PI and no PO? The logic is not clear.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules