Hi All,
I am a little rusty with the VBA programming, but I think a macro be the only solution to my problem (list is 70,000 lines long). I am looking for general ideas on how to get started? If anyone has functions, great, but there may be other ways to do this that I can't think of right now.
I have created macros for indented BoM's in the past, but the problem I am running into is this:
-There is no designated top level assembly
-Therefore, I have no idea when a component reaches the top level of the assembly. (would this be a repetitive search from 'component -> Assy -> component -> assy' until there is no found, which assumes the top level?)
-Finally, multiple components go into multiple levels of assembly.
Here is a rough estimate of the data I have:
Assy Component Sequence
Item A Item B 10
Item A Item E 20
Item A Item F 30
Item A Item G 40
Item B Item H 10
Item C Item A 10
Item C Item I 20
Item C Item J 30
Item C Item K 70
Item C Item L 80
Item C Item M 90
Item D Item N 10
Item D Item O 20
Item D Item P 30
Item D Item Q 40
Item D Item R 50
Item D Item S 60
Item D Item C 70
Item D Item T 80
Item D Item U 90
Item D Item V 100
Item D Item W 110
Item D Item X 120
Item D Item Y 130
Item D Item Z 140
Item D Item AA 150
Item D Item AB 160
Item D Item AC 170
Item D Item AD 180
Item D Item AE 190
With my desired output being a standard top-down indented BoM.
Thanks in advance for the discussion.
Bookmarks