Hey guys. I got a question, and hopefully it isn't too difficult. I just can't seem to think of a way to do what I'm wanting to do. I'm creating a work schedule for my employees, and want to create a macro that I can run that will create a new sheet named whatever the next year is, and then formatted the same as the one already made. So, basically the new sheet will look exactly like the previous, but be updated with that year's dates. All of that is simple enough, and I can figure that out. My problem is that our work schedule is not a normal mon-fri 9-5 schedule. I've got 4 crews and all of them follow the same 28 day rotation, but on different days. So, in column "A" I have dates (Jan. 1 - Dec. 31), in columns "B"-"E" I have the schedule. The pattern is: DDD O NNN OOO DDDD OOOOOOO NNNN OOO (D = Day, N = Night, and O = Off)
So, is there a way that when a macro creates the new sheet for the new year, it can automatically continue the pattern in Row 1 where the last sheet left off?
So, is there a way that when a macro creates the new sheet for the new year, it can automatically continue the pattern in Row 1 where the last sheet left off?