Select certain columns based on certain date displayed in Row 1

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!

See attached file, I used this macro:

Please Login or Register  to view this content.

Regards,
Antonio

wow awesome thank you so much!