Consulting

Results 1 to 2 of 2

Thread: please help in vba macro--Compare and merge data given in parent child hierarchy

  1. #1
    VBAX Newbie
    Joined
    Jan 2020
    Posts
    1
    Location

    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.
    Attached Images Attached Images

  2. #2
    Knowledge Base Approver VBAX Guru
    Joined
    Apr 2012
    Posts
    4,715
    Thank you for the pictures.
    Just what I was looking for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •