I'm trying to create a multilevel/indented bom from a flat bom. The flat bom would look similar to the attached with the output indented bom also on the attached. My first thought is to search the assembly part number in the columns and output the rows in which they appear.
Thanks in advance for you helpBOM TEST.xlsx
I am assuming that there will be multiple "top level" entries, each with their own sub-levels. Will they all be three levels across, or are there x-number of levels across?
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
The levels in the first three columns is intended to be a visual indicator of where the part falls within each assembly. My first step that I'm trying to do it get the part number to land below the assembly number, and as you can see part numbers can be in multiple assemblies. Nuts, bolts, washers . . . The second step is to populate an X in the level columns.
I'm still not getting my question answered. I'm referring to the levels in the input table (assem1, assem2, and assem3). Could there be more?
It's possible that there could be more. I think [10] max would be safe.
I'm seeing that the items aren't in any particular sequence in your sample data. For example, the Wheel is in row 5. In row 6-8 are items for Wheel, Large Wheel, and Small Wheel, even though Large and Small wheel don't appear until row 10-11. Is that typical?
Also, let's say another top level, "SCOOTER", appears in row 12 with subsequent items. Could more items for BIKE still show up later, or will all subsequent items be for SCOOTER until the next top level?
For your first question, it would be typical to appear as you described.
For your second question, more items for BIKE could show up. This was a condensed version of a BOM that could have 200+ lines.
Thanks
If the items can't be counted on to be in hierarchical sequence, and the number of levels can vary then it presents a coding challenge. Could you please attach actual data, or at least a more representative sample? The above attachment isn't really enough to go on.
This one may be a little more realistic.
Give this a try. It will clear Sheet2 and create the multi-level structure there.
Please Login or Register to view this content.
Last edited by natefarm; 11-21-2014 at 06:12 PM. Reason: Fixed alignment problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks