Forum Discussion

Brass Contributor

Jan 15, 2020

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

excel

Macros and VBA

kevinduque
Jan 15, 2020
thank you so much you have been very helpfulPascalKTeam

PascalKTeam

Iron Contributor

Jan 15, 2020

What is "Data 1"? A Sheet?
Please provide more details, if you could post the file, that might help

kevinduque
Brass Contributor
Jan 15, 2020
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
Recon.xlsx10 KB
- PascalKTeam
  Iron Contributor
  Jan 15, 2020
  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
  consolidate in one sheet.xlsm28 KB
  - kevinduque
    Brass Contributor
    Jan 15, 2020
    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?