Compare current Excel workbook to next most recent and determine rows to delete
Posted on 2014-01-03
I have a spreadsheet that I download weekly, which contains a growing dataset so each file contains the same rows as the previous PLUS any new rows created. Assuming I have the most-recent file open, I need to...
- Open the next-most-recent spreadsheet in a given folder
(Each file has a name that represents the date of its download, "12202013.xls" for example, if that helps identify the next most recent file)
- Count the number of rows in that file
- Go back to my most-recent file
- Delete that number of rows (counting from the top)