ravishankar helped me with a macro in the past.
I am now wondering if it would be possible to modify it to perform 1 extra function.
What it does is matches data between 2 sheets, comparing sheet 2 with sheet 1 and updating values in sheet 2 from the data provided in sheet 1.
I attached a working sample. you will notice "Destination" has 4 rows of data, while "Source" only has 3, would it be possible to then highlight or alter in anyway the row in "Destination" to indicate that it has no match, that there is no source data point to compare that specific row/cell too in teh "Source" sheet.
Thanks for all your help
Bookmarks