Automatically run macro on the 1st of each month (or the first time the doc is opened after the 1st of the month)

[momentumons]

Hello! I have a sheet with a live forecast. I'd like to simply copy & paste the whole sheet into a 'prior forecast' tab in the same doc. (Paste as values). I'd like this to happen on the first of every month - this will then be used to compare the current fcst to the previous one.. As it's not just me using this document I really want it to happen automatically so that people don't forget the process. Is there a way I can write a macro that will run on a specific date? Or a better way?

My live forecast tab is called "FORECAST" and I don't yet have a "PRIOR FORECAST" tab but that could be called anything!

The data range to be copied & pasted as values is A:Z.

Thanks

 

[HighAndWilder]

You can set up a procedure to run when the workbook is opened.

This is placed in the ThisWorkbook code module.

Sub Workbook_Open()

     ' Run code here.

End Sub

Before you run the code you will need to check that the action that you are going to perfomr has not already been done.

You could keep a hidden tab which holds a record of when the action was last completed. This tab could hold a history of what, when and who.