Jul 26 2022 05:00 AM
Im creating a rota for work and am trying to get the sheet to reset at the end off the week to specific values.
My thought atm is that when todays date=the beginning of the week date+7 then the sheet reverts back to its default, or copies and pasts a clean one onto it from a locked sheet.
Thoughts?
Many Thanks
Jul 26 2022 07:56 AM
Why not just create a Template and use it anew each week? That seems to be the effect of what you're describing anyway.
To create a Template, just create that clean sheet you talk about and do a Save As Template
Jul 26 2022 01:21 PM
Jul 26 2022 04:50 PM - edited Jul 26 2022 04:50 PM
A template doesn't have to be totally blank. It can be whatever you're describing as the default state--you describe it as "every x number of weeks a sheet is wiped clean and they can start again"--that one with which "they can start again": THAT is your template. All they'd need to do is open the template up and start using it,
Does THAT make sense?
Jul 29 2022 04:25 AM
Jul 29 2022 08:08 AM - edited Jul 29 2022 08:08 AM
This was your very first post, with emphasis added:
Im creating a rota for work and am trying to get the sheet to reset at the end off the week to specific values.
My thought atm is that when todays date=the beginning of the week date+7 then the sheet reverts back to its default, or copies and pasts a clean one onto it from a locked sheet.
And the template could/should be something that perfectly satisfies that emphasized part. It is the sheet into which the new week's starting date can be entered--presumably your Excel novices could handle that, and you could use data validation to ensure that it's in Excel date format--and from there whatever defaults are present will also be present.
Your most recent concern:
it might have to be a temporary work around, but I don't think it has the final desired outcome unless I'm missing something. Sorry for my terrible description, if having to open and save a new file each time from the template each week then that probably wont work long term
I think you may be missing something (or there's something I'm missing from your description of the work situation): you don't need to open the template each time you open the file. Once opened at the start of the week, you/they would save it using whatever convention you are using for naming it==e.g.,, "Rotation_7_29_22.xlsx"--and thereafter, for the balance of that week, they use that file.
OR, if there's no need to keep archives of past weeks, "CurrentRotation.xlsx." In fact, once a template has been opened and entries made, it prompts you to save as an xlsx file anyway. People would need to learn to start with week (or whatever period you're following) with a fresh file, but beyond that current practices would apply.