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!
Bookmarks