Hello Karedog

Everything seems to be working great - again thank you.

Using excel 2016 - 32bit with 8 gb ram

Part of this for me is to learn - A lot of what you are doing I do not understand could you possible notate the reason for the loops, would give me a start on understanding.

I have included what I would be including next which is getting info from other tables and or columns and adding it to the structure. I added the table and put in 2 possible displays. The later is different on the placement I was curious if you thought this version was a more readable format or was more program friendly.

Also once I understand (hopefully) I would like to add the reversal of extracting a BOM from top down (1 or many levels) and also flattening the BOM and adding up the qty used. I have seen many examples for the later solutions but I want to keep the same technique.