Forum Discussion
Solved
consolidate names from two different sheets ( summarizing the unique values)
HI Team,
Id like to know if someone could help me get the VBA for this concern I have, I am doing a reconciliation of two raw data - each raw data has names (some maybe in Data 1 or Data 2 or perhaps only in Data 1 and Data 2). Id like to know the VBA to basically get those names from both Data 1 and Data 2 and consolidate it to new sheet automatically .
thank you so much you have been very helpfulPascalKTeam
9 Replies
- What is "Data 1"? A Sheet?
Please provide more details, if you could post the file, that might helpPascalKTeam I attached the file, basically I wanted to automatically consolidates the name in the first and secodn sheet to summary sheet. The summary Sheet is the output
Hi kevinduque
OK I see, that helps a lot
Please click on the elephant in the attached file and see if it does what you expect
