Using Access I export/create a daily Excel spreadsheet which has an increasing number of records/rows.
I'd like to then open a master Excel sheet, which:
Opens the exported sheet.
Counts the number of rows in the exported sheet which have data, then
Copies a particular row in the master sheet, down the same number of rows that there are records in the exported sheet, plus 1.
I used to do this in Lotus, but Windows 7 won't work with 1-2-3, and the macros won't convert.