Compare and Amend over 2 spreadsheets

[sjuk86]

Hi, i'm really sorry if I'm confusing here but i have a main sheet with code and addresses that link to those codes. However each month i get updates, and at the moment i have to search each individual code (over 2000) and make sure the address is still correct.
Is there any way of running a macro to compare the 2 sheets and automatically make the changes?
sorry again if this doesnt make sense, and thanks in advance for your help.

 

[Dannyh1]

Hi,

Maybe you could just do a vlookup between the 2 sheets?

 

[sjuk86]

Hi, thanks for that, will that replace the data if its different then?

Thanks

 

[Dannyh1]

Hi,

I am guessing it will work something like this:

Sheet1 = Your master data
Column A = Codes
Column B = Addresses

Sheet2 = Updates
Column A = Codes
Column B = Addresses

In Sheet1

C2 = IF(ISNA(VLOOKUP(A2,Sheet2!A:B,2,FALSE)),B2,(VLOOKUP(A2,Sheet2!A:B,2,FALSE)))

Column C will now have combination of Existing Info + Updates

Copy & Paste Values only column C into Column B (& get rid of column C)

Is this what you need?