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 per...
thank you so much you have been very helpfulPascalKTeam
PascalKTeam 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
PascalKTeam Thanks Team - what part is the sheet 1 and sheet 2 shoudl I link the macro in the summary tab? do you have ways to automatically give an output without clicking the elephant?
- Sorry I don't understand what you mean...
There must be a trigger that starts the VBA. Of course it can run every time you click or every time you paste something or every time you open the file or whatever but you need to specify a trigger. Of course you can change the elephant into a normal button if that helps 🙂PascalKTeam can we make it run standalone like everytime it detects a value in the A column of both sheets it will run?