This didn't work I got the same thing #ref.
Let me know if you can think of something else.
Thanks!

--
Miss Karen


"MyVeryOwnSelf" wrote:

I have a spreadsheet with about 500 rows on it and it calculates in
different fields down the line. It has the 12 monthly columns at the
top and every month I go in and delete out the one on the left side
and add the new column at the right and then I have to redo all of the
formulas - is there a way I can do this without having to key in the
formulas again. Thanks!

This may or may not work, depending on the formulas.

Instead of deleting column 1, copy columns 2-12 and paste onto columns
1-11.

Then update the constant values in column 12.