I have a huge Excel spreadsheet with something like 5000 rows and 70 columns packed with dense data (text and numbers, no formulae). That was an extract from a data source about 3 months ago. I am just getting another huger spreadsheet current as of yesterday. I am supposed to transform this data in several ways and even upload a portion of it back to another database.
Is there a easy way to compare these two Excel sheets, row by row, highlighting cells that are not the same? I can then work on only those (changed) cells, hugely saving my time.
Is there an easy way to accomplish this? I am no Excel or VBA expert, but can handle small macros or VBA procedures. Any 3rd party tools available?
Sincerely appreciate your help!