Hello,
I have a workbook with 8 spreadsheets for different business units. These
spreadsheets contain lists of customer information. The two key columns in
these spreadsheets are 'START-DATE' and 'ARCHIVE-DATE'. The start-date is
entered by the user and the archive-date is simply that start-date plus 7
days.
I need to automate the task of selecting the rows where the 'ARCHIVE DATE'
column is equal to todays date. These records will be deleted from the
spreadsheet and archived in an access database. I was hoping to set it up so
that when the workbook is opened, this archiving process will be automated.
What would be the best way around this problem?
All suggestions will be gratefully received
Bookmarks