PDA

View Full Version : please help in vba macro--Compare and merge data given in parent child hierarchy



vj523
01-15-2020, 06:56 AM
Hello Everyone, i have 2 data table in parent child hierarchy as given in attached snapshot. Now i need to create 1 table by merging both table. it should check the every child corresponding to the parent, if there are 2 child in first table and 2 child in other table for same parent then under the parent 4 child should be visible. please refer attached snapshot.

Number of row and column will vary in table and child object can be parent for other.
i am looking for a solution in excel vba.
In case of any question, please let me know.
Your expert advise would be very helpful for me.
Thanks in Advance.

snb
01-15-2020, 07:07 AM
Thank you for the pictures.
Just what I was looking for.