Hello,

I'm looking for assistance with creating a macro that will find matching data in Column A from two workbooks and update the data in column B and C from the newly generated report to the master report.

Workbook1 = Master
Workbook2 = NewReport
Master Active Worksheet = sheet1
NewReport Active Worksheet = sheet1

Example: Master Sheet1
A,B,C,
Name, Age, Weight(Row1 Header)
Tom, 20, 150
Bob, 35, 210
Carl, 43, 170

Example: NewReport Sheet1
A,B,C
Name, Age, Weight(Row1 Header)
Tom, 22, 153
Bob, 35, 215
Carl, 44, 170

The macro should take the data from the NewReport, compare column A's data to the Master for matches, when matches are found it should then update the data in the Master spreadsheet. The macro will need to by dynamic with the ability to update the information regardless of what order the data is presented in and also should be scalable as the reports grow in size.
Any assistance would be appreciated.

Thank you,
E