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.
https://i.stack.imgur.com/4ndLI.png
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: https://stackoverflow.com/questions/66319874/how-to-update-bom-hierarchy-tree-with-help-of-vba-if-parent-was-not-found
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.