create a vba code to do the copy and paste as value task at end of each month 23:59:59

[chuath]

Dear experts,

I have the following table and column E contains formula linking to another workbook to update the PM done date. At the end of each month at maybe 23:59:59, for example Dec, I want to copy column E for Dec only and paste as value to the same cells. Similarly at end of Jan, copy column E for Jan only and paste as value to the same cells. And so on for the subsequent months. Pls help to create a vba code to do the copy and paste as value task at end of each month 23:59:59. Pls refer to the attached excel file. Thanks.

picture.jpg

[dflak]

The code is simple

Please Login or Register  to view this content.

As for scheduling it to run, I suggest you look at the following documents to use the windows task scheduler to run it.

[chuath]

The code is simple

Please Login or Register  to view this content.

As for scheduling it to run, I suggest you look at the following documents to use the windows task scheduler to run it.

Hi dflak,

It works. Thanks.