Newbie, here. Just gotten started with VBA over the last month or so, so i am still on the not so steep part of the learning curve.

Here's my problem. I have an excel workbook with a worksheet for each of the 5 weekdays. At the start of each monday i want to get vba to take certain values from the previous friday and insert them into monday after clearing the cells (it is a fresh week after all!!). Part of the problem is that the spreadsheets will be accessed several times each day, so the program will need to recognize that it is a new monday once and then keep track of the dates after that.

It seems everytime i try to do this, all of my parameters are based on the current date and essentially the process keeps resetting its own baseline.




Help.