Rearrange Hierarchical Data

Originally Posted by nilem

Hi Stusic,
maybe so

Sub...

Maybe so? Certainly so! This is fantastic!

I've got to modify it a bit to remove the hierarchy numbers from the first column and move the part numbers so they are in column A & B, then bring in the quantities from column H, but that is no problem. Your code is over my head, but I can add it as a separate sub a the end.

Thank you so much for your help! This is going to save so much time