VBA to 'actualise' data based on today's date

Hi all,

I'm trying to automate the process of actualising sales data every month. I have developed a planning tool that forecasts sales of 1000 stores. So at the end of each month I actualise the previous month as soon as the data becomes available. Instead of doing that manually, I want to write a VBA that checks the date on my computer and then actualises up to the most recent 'cut-off date'. I put each month's cut-off date in Row1 to have the VBA match it with today's date and then actualise accordingly.

Important: the code is supposed to actualise all (!) months except months after today's date (so including e.g. FY 2016 data), as exchange rate fluctuations affect sales and thus changes the data slightly every month, and then eventually paste all data as values (!) to reduce the file size.

I started writing some code, but I'm sure there is an easier/ more efficient way to do it.

See attached file for your reference.

Please Login or Register  to view this content.