Hey there!
Need a little help building out an iterative macro that checks for levels of parts.
As an example in this sample data. 19052 would be a Parent Part. It is made up of the child parts 19052C.2, 19250, 92922.2, and 92934.5.
The part 19052 and the records 2 through 5 would be a Level 1 part, as they go into a top tier.
The records below with PartNumber 19032C.2 would be Level 2 parts, as they go into making Level 1 parts.
The records with PartNumber 90062 would be Level 3 parts, as they go into making Level 2 parts. So on and so forth.
There is an undefined level of parts.
I know I need to make an iterative macro to loop through them and section out which records, but I've been staring at the problem for too long!!
It's preferable that the levels take place after the other work that has been done!
