Forum Discussion
Auto replace sheet x with y if z?
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 s...
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
- Trouble is I wont be the one using it. I'll be locking all cells apart from a couple that are restricted to a drop down list, and if they have to do more than one thing other than open the spreadsheet and change times and names then I'll come into work and the computer would have spontaneously combusted XD they cant be given too much freedom.
The plan is to have it all nearly automated so they open one file and every x number of weeks a sheet is wiped clean and they can start again.
I have equations dependant on the names of the sheets so cant delete the entire sheet and create a new one, has to have the existing ones re-set to default.
Hope this makes sense.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?
- That does and 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 have seen their file management and there's a good chance someone will delete the wrong things or will end up with several of the same week or files months old, this is what I'm trying to avoid.
Many Thanks
