Forum Discussion
Worksheet and import data
eoghan61 Don't understand the question, sorry. What do you mean by "making holidays somewhat smart"? Furthermore, it's probably a bad idea to want to create something that automatically rolls forward into another sheet. I believe the schedule is already complicated as it is right now.
But perhaps you can just add months below the current months and hide the ones that have passed. E.g. copy rows 12:14 and paste them to rows 60:62 and update the formula in A60 so that it returns January 2023.
And with regard to the shifts going off pattern, I can't really tell where that happens.
This is my ultimate goal hopefully this help you understand what i would like to do.
correction the pattern is running fine i think 😉
What I would like to do is make this rota generator so to speak available for the reset of my team and teams that work a different shift pattern so that if we create a new sheet it looks at the previous year and automatically continues the pattern including updating the dates of pay if that makes sense
eoghan61 Clear in your mind. Not in mine. Sorry!
My gut feeling says that in the new year you should update the information at the top and set the first date for the new shift pattern, based on where you left off in the previous year. Wouldn't really know where to start automating that or how.