Macro below should do following:
When workbook opens, checks Col C of the "Approved" sheet.
If any rows are dated earlier than today, it moves the row to the first free row of tne "Expired" sheet, and deletes the blank row in the "Approved" sheet.
All suggestions and guidance welcomed as everPlease Login or Register to view this content.
Ochimus
Bookmarks