I need some help please to refine this code. I need it to:
1 - Compare sheet rows using reference numbers in column A in sheet "Updates", with reference numbers in column A
of sheet "Existing".
2 - If a match is found, then have the contents of the matching row from columns A through to X of Sheet "Updates", copied over to replace the same found in columns A through to X of Sheet "Existing".
3 - Then repeat this action for ALL ROWS in Sheet "Updates" until the last row (which will vary) has been checked. Then report on how many rows were updated.
I can get the code to replace the entries in ONE row (the last row) where a match is found, but not ALL rows. It also reports that ALL rows have been updated when they haven't.
Bookmarks