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.
Reply With Quote