How to update BOM hierarchy tree with help of VBA if parent was not found?

I have a BOM (Bill Of Materials) parent/child hierarchy in column "J" that needs to update if the child's parent was not found. So as you can see in the image row "1.1" has no cell with "1" above it meaning that there's no such parent. So logically I'd need to get rid of it in the whole branch.

Maybe there's a ready solution for reorganizing (updating) the hierarchy tree if the parent was not found above in the same column i.e. "J"?

Read more here:

Content Attribution

This content was originally published by Edd at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: