I have a sheet (old version), it has say 4 columns of data on multiple rows (can be thousands).
On another sheet, I have the same data (new version), however some rows might have changes...
I need vba code to compare the new data with the old data. If there is a change on a row ideally I want to highlight that row a color (grey for example but I can mess with this later).
The idea behind it is that a person will have to update the rows, and I want to highlight out the rows that have changed so they don't have to actually update every row every time, but just the ones that have changed.
I know I can do this with an insane loop, but again I'd like to avoid loops if possible due to the data size and processing time it would take.