Penny:

There is no easy way to copy a row up.

You can set a macro that would do what you wanted using the macro recorder.

Menu Tools macros create

As it is the first row each week you basically

Copy the last week's row and insert under the last row. If the formulas are
not changing then you could copy paste special values and again (formats).
(This will keep the sums intact).

Then look at the top row and delete the data that you need to enter (not the
formulas) and then stop the macro

Make sure you save the macro in the work book by creating it in the work book

Happy macro writing.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Pammy" wrote:

Is there an easy way to copy formulas up without dragging up? I have a
spreadsheet that has 4500 rows of info, I want to add the latest infor at the
top row starting in row 50 each time, but when I insert the info I have to
copy and paste the formula. Easch week I will be adding new info at the top
and I don't want to have to drag the formula if I can keep from it.