Hi guys,
I need your help!
I'm trying to design a macro but I just can't get it right. The problem is as follows:
I have a sheet with data for each month from January 2012 to December 2018. The cells are linked to another sheet, but each month I need the data to be copied and pasted again as values to get them fixed like they were in this certain month. So one example:
It's June 2013 which is displayed as text "June 2013" in merged cell "CQ1:CT1". If the actual month (connected to todays date) is June 2013 I need Excel to select the whole columns CQ, CR, CS, and CT. Then copy and paste the values.
This has to work for every month in the years 2012-2018 and would be best to be in a macro.
Can anybody provide me with a macro like this?
Thanks in advance!
Bookmarks