Hi All,
Bit of an odd Marco creation request for some of the users I support:
I need to build a Macro that can compare values on two different excel spreadsheets/tabs and note if they differ.
The spreadsheet data would be downloaded in CSV from a software platform, and the users should be able to put the sheets together in one open Excel book, click a button and it goes through and highlights changes from one sheet to the next one, see example of desired result; sheet 1 contains information from an export from 1 day, then sheet 2 an export from a later date, then the macro should be able to be activated then outline which values differ, on a unique ID basis.
Psuedo:
If
ID sheet 1 matches ID sheet 2
then
Compare row and highlight where differing values are.
It does not need to be exactly like this, very open to other ideas but I need to be able to compile it in a button on their tool bar
Bookmarks