Hi,

This is a follow up question to a previous question I had around macros.
Not sure if I should use a macro or a function in this case.

I have File 1 (master file) with a total of 1000 rows, and File 2 (which
contains 20 of the 1000 rows) -- identical columns

For example:

File 1

Name ID
A 1
B 2
C 3
D 4
E 5

File 2
Name ID Changed (extra column)
A 1 No
C 6 Yes
D 4 No

How can I create a macro/function to only change the ID cell for "C"? I
have inserted a "changed" column in File 2 to help me identify those that
have changed.

Thanks!