Thanks Michael. I have sheets that go from July 2018 to June 2019. The file name for instance is 2018-2019.xlsm. After June 2019 has gone and a new document needed, I want a button that will make a copy of the spreadsheet with the new name of the document for the new financial year. Do you have any ideas how I might go about doing that?
Eventually I will want that but I was talking about for now, I just want to press a button and for a new document to appear and for it to be an exact copy of the already open document. The filename of the new document needs to be set to June- July of the next financial year.
I will also want the sheet names to be updated accordingly, but I think I know how to do that one, but I guess, if you could also add it in here incase I can't work it out.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.