Bit hard to be sure what to do without seeing the spreadsheet including
formulas if any.
However, instead of copying and pasteing, is it possible to 'Cut' the last
row of data and use 'Insert the cut cells' into the first row which moves
everything down one row? If you have any formulas with references to other
cells then you would have to check what they do.

Regards,
OssieMac

"Steve" wrote:

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