Getting the string "bom parent" for an item

[Big Joe]

Please delete, as i´ve also posted question on Mr. Excel and i was not aware of cross posting, sorry

Mod Edit: No need to delete (see my post below). Here's your original post:

Hey I found this code by a guy called to

Please Login or Register  to view this content.

And it works like it should, but is not build for the large amount of data i?m looking at
I have a data set that looks like this, but can be 11 levels deep and with over 5000 lines
Pos. Item
1 1 4535326
.2 1 3416279
..3 1 8364148
.2 2 3417872
..3 1 8364146
.2 3 3417694
..3 1 3418757
...4 1 3419804
....5 1 400006499
...4 2 4319406
..3 2 4319405
..3 3 3419223

I am looking for a VBA code that can give me the string so my data set will look abit more like this and not take hours to run
excelsnip.jpg

I?ve been told we should put the data into an array
I have also asked on mr.excel

[AliGW]

Administrative Note:

Welcome to the forum.

There is no problem as long as you tell us, so there is NO NEED for this thread to be deleted.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I have added the link for you this time: https://www.mrexcel.com/board/thread...arent.1220534/)

[karedog]

For your problem based on your description here and on MrExcel, the code should be like this :

Please Login or Register  to view this content.

[Big Joe]

My challenge was met by a legend WBD who send me a code and it took what were 8 hours or more down to mere seconds.
I would leave a link here if anyone finds them self in the same spot as me, but i´m able to.
But Karadog´s code is also epic and works, thx!!!

[karedog]

You are welcome, and many thanks for reputation point given.

And don't forget to mark this thread as solved :
please select Thread Tools from the menu link above and mark this thread as SOLVED.

Regards