Workbook reset after year change

[MarkMeister]

Hi,

I’ll try and explain this as simply and as easy as I can, here goes…

I have a workbook with various different tabs that need filling in, the workbook runs for one year.

The workbook currently has a drop down list that allows you to change the year (2024, 2025… etc.) and the weeks (dates) automatically change based on the year.

Now… is there a way that when the user changes the year to 2024, the entire workbook’s data is reset, but only for that year? If they were to go back to 2023, for instance, all that data entered would still be there, and subsequent years also.

I hope I’ve made myself clear!

Thanks everyone

 

[Bosquedeguate]

Do you have tabs (sheets for the previous year(s))?
For the new year are you just duplicating a sheet(s) for the next year?
When you say "reset" what do you mean? I assume you want the new year to have initial values, cleared values, etc.

Possibly the best way to implement this is to have a set for Sheets that have your initial values in it. Then copy these sheets for the new year in your workbook. Keep you initial sheets protected so that you do not accidentally put data in them. Or put your cleared/iniitialized sheets in a separate Workbook and only open that workbook copy from for a new year.

 

[MarkMeister]

Do you have tabs (sheets for the previous year(s))?
For the new year are you just duplicating a sheet(s) for the next year?
When you say "reset" what do you mean? I assume you want the new year to have initial values, cleared values, etc.

Possibly the best way to implement this is to have a set for Sheets that have your initial values in it. Then copy these sheets for the new year in your workbook. Keep you initial sheets protected so that you do not accidentally put data in them. Or put your cleared/iniitialized sheets in a separate Workbook and only open that workbook copy from for a new year.

It’s a data sheet for water hygiene we use at work. The data entered is for water temperature and ph levels stuff like that.

There’s different tabs on the workbook itself but all the data for ‘that year’ needs to be viewable for an auditor.

So when I look at the 2023 sheet I can see all the data for that year.

When I change the year to 2024, I initially would like the same workbook to be empty and then the data to be filled in for that year as we need to. Click to 2025, the same sheet would then become empty again