please help in vba macro--Compare and merge data given in parent child hierarchy
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.