Hi, I am trying to figure out how to create a macros that would save the workbook every 3 to 4 hours automatically and at 5am it copies information from one workbook to another one. The workbook is open 24 hours a day. I have used the Application.onTime, but it only works one day, on the 2nd day, 3rd day etc it doesn't start the macros. I then created a macro to save and shut the workbook down and reopen it, hoping that it will start the Application.onTime again, but that didn't work either. Any help would be appreciated. Thank you.