You need to add $ to you formulas

If you have Average(C1:C60)
change to Average(C$1:C$60)

"Dennis G" wrote:

I'm sure this is trivial -- I have a worksheet that consists of basically
stock data that is refreshed on a daily basis -- I insert the high, low
close, previous close ,volumes, etc. I'm using this information to calculate
daily trading ranges and using that information for the past sixty trading
days to calculate moving averages etc.

When I insert the current data into my worksheet the formula's I have tied
to those cells shift down one row. Is there a way of delinking the formulas
such that when I import the data I'm not copying the fomula's to the new
cells ? What I'd like to do is insert the day's data at the top of the
worksheet and have the 61st day's data (at the bottom)be ignored and use the
most recent sixty days.


thanks,

Dennis