I am looking for a macro that would do the following:

On specific date or say the 25th of each month if the spreadsheet is opened up the macro would copy A1-A14:L1-L14 then paste it in a specific workbook name PR. Each month it would make sure to just copy and paste under the previous months data. Then the macro would take H2:H14 and copy the current values to G2:G14 then save the file.



Basically I am trying to move data to another workbook for tracking and history and then use the main workbook for a month tracker with updated data.

Is this something I can get help writing or can you point me in the direction of where I could find some information to achieve this goal?