Code to paste as value when last data is less than today

[jp16]

I have 2 tab. One is Daily Forcast, one is Actual. Currently, we type in our Forcast amount in the Actual tab. Then everyday, when we see our bank statement for yesterday, we copy and paste yesterday as value in the Daily Forcast to keep a record. Then we would overwrite the value in Actual Tab.

However, i hope to have a code that will copy and paste the value up to yesterday when i open my file first time today. I mean let say today is 08/04, and my last data in Daily Forcast is up to 05/04. When i open the file, it will copy and paste as value from Actual tab to daily forcast tab 06/04-07/04.
Then tomorrow, 09/04, when i open my file in the morning, it will copy and paste 08/04 n paste as value in Daily Forcast tab.

[JLGWhiz]

this is workbook event code which will run when the workbook is opened. So that it will only execute once per day, when it runs and executes a copy and paste action a "C" will be placed in row 2 for that date. This will then prevent the code from executing any further copy actions for that day in case the workbook is closed and reopened.

Please Login or Register  to view this content.

Copy and paste the code to the 'ThisWorkbook' code module.