The formulas normally adjust when rows are deleted or added. For example if
in Cell A1 you have a formula =A40 and you add or delete rows between the 2nd
and teh 39th row the formula adjusts automatically. Am I missing something?

Alok

"k9kapers" wrote:

Excel 2002
I am setting up a Day End report of sales and expences to pull information
from various spreadsheets.
If the source sheet row moves the result is not accurate. For example if
within the source sheet rows are added or deleted and the "total" row moves
up or down, the report gives the wrong answer or a 0.
Is is possible to make a reference to a cell that is not static?