I recently asked for help on two different problems on a workbook I inherited from a past employee. Now that the original problems are fixed and the workbook is working as intended, I have discovered a new problem. (I think/hope the last)
Column G "Status" is used as the process is worked each session. A session typically consist of a shift. I don't want the data in that column to be there when the workbook is reopened by a new supervisor the next day or the next week (This process is not always done every day). The data is only valuable during a particular session. I would like to know if it is possible to delete the data based on a timer. (The example that I included only has one sheet "Test Shift", but in fact there is a sheet for each shift "Days", "Swings" & "Graves") I would like to have the Graveyard shift clear the data after 02:00hrs, Dayshift clear after 10:00hrs and Swingshift Clear after 18:00hrs. I am asuming the file has to be open for it to perform this action. Maybe it can be set to run when the file is opened.
I would appreciate any help or direction on this. Ratcheting-List--Post-Copy-r1.xls