data conveyor

[zobufeja]

hello.
i can`t figure out how to make what i call a "data conveyor"

lets say i have a set of formulas that analyaze data in columns A and B.
formulas are located in C2000 to F2050 with references at A2000 to B2050

is there any way to "push" the data down in the formula reference area one row at the time. As i need to analyze historical data one day(row) at the time.

Deleting a row below the reference does not work.. excel keeps changin the reference points.

[tuph]

I may be stating the obvious, but it sounds like you need to make the cell references absolute -
e.g., A2000 is a relative reference, $A$2000 is an absolute reference and shouldn't change.