S
Steve
Hi,
I have a rota in a sheet. It is 7 columns wide (Sun-Mon) and 30 rows (weeks)
deep. When completed, a rota may cover one week; thirty weeks or any
combination in between.
I need to be able to increment the rota either 1 day forward at a time or 1
day backwards at a time. Example, moving a two week rota forward, day 1
becomes day 2, day two becomes day 3 ... day 14 becomes day 1.
Moving a value to a 'holder' then moving other values one-by-one is too
slow. Any suggestions?
Steve
I have a rota in a sheet. It is 7 columns wide (Sun-Mon) and 30 rows (weeks)
deep. When completed, a rota may cover one week; thirty weeks or any
combination in between.
I need to be able to increment the rota either 1 day forward at a time or 1
day backwards at a time. Example, moving a two week rota forward, day 1
becomes day 2, day two becomes day 3 ... day 14 becomes day 1.
Moving a value to a 'holder' then moving other values one-by-one is too
slow. Any suggestions?
Steve