Hopefully this is a simple process, but through all the variations of google searches, while some work, it's not a complete solutions.
I have a workbook for 2022
This workbook has 12 month worksheets
Yes, it's a calendar of sorts...
It comprises of Monday to Friday Only no weekend days are shown
and broken into Weeks for each month.
it totals data each week, and moves that data to the bottom of that month worksheet, then copies that data to a master sheet.
Each day of the week is labelled Mon Jan 1, Tue Jan 2 Wed Jan 3 etc
Is there an automated way to create a 2023, 2024 file, that contains all the same worksheets, with same sized columns, and formulas doing the same thing
Advance or replace the correct dates for each of the weeks of that particular year, contained in each sheet
I'm taking this over from someone that had a good idea but is no longer available, and when I created 2023 copy, I had to go through each
Monday to friday week and change the date of the day and year and tweak a few cells
Appreciate the assist if possible, or a direction to figure out how to automate this, instead of doing it manually