View Full Version : Comparing two spreadsheets
| I receive a spreadsheet each day. At the top it has some header rows and a logo. At the bottom there are some footer rows, some blank rows and a logo. What I want to do is compare the spreadsheet to the previous days, and create a list of rows that have changed or which are new. Where do I begin? |
| Originally posted by microgenius build a macro in a seperate spreadsheet that will set spreadsheet1.row1 = spreadsheet2.row1. that field will return true or false.Build a macro loop that checks each row until the end of the document. all falses are changes or new. Thanks for this, although it's a bit more complicated than that. New can can be inserted anywhere - not just at the end. So I need to strip off the headers and logos and then sort, then compare. So I'm still stuggling with this. |