Combining Records of two sheets with Loop till Unique ID
Hi,
I am making a family directory and have two sheet of records with unique Parent ID same in both sheets , 1st sheet is the details of Parents and second sheet is with Family members or childs. I have multiple records in sheet 2 reference to parent ID.
I want to combine this using mail merge and want all the records of 1st sheet coming at top of my mail merge sheet and below want all the child Family members come with respect to above Parent ID
Please Guide.
|