Hi cyn22,
And another way is:
Cut the top cell of the original bunch then paste into top cell of new
bunch. Fill this pasted top cell of new bunch down to desired bottom
row. Go to the cell in the origin bunch that is below the cell you cut
and copy/paste or fill up to return it to its original state.
Pasting from a Cut does not alter formula's references, but it does
delete it from the cell you cut and therefore has to be replaced by
Copy/Paste or filling from a neighbouring cell with the same formula
Ken Johnson