Way to keep formulas unchanged when deleting rows?
Yes, I meant Sheets, sorry about that. I will give this a try.
Thanks.
"Gord Dibben" wrote:
=INDIRECT("A" & ROW() + 4) entered in B1
BTW........what are "other pages"?
Do you mean other worksheets?
Then you might want
=INDIRECT("Sheet1!A" & ROW() + 4) in those other sheets.
Gord Dibben MS Excel MVP
On Tue, 17 Nov 2009 10:10:01 -0800, PeteJ
wrote:
Thanks. But this makes the formula non-copyable to increment. so would this
work:
=INDIRECT(CELL($A$5))
??
"muddan madhu" wrote:
=INDIRECT("A5")
On Nov 17, 8:02 pm, PeteJ wrote:
I have a bunch of references to some data that I copy into a datasheet.
Occasionally, this data has some blank rows or rows with unneeded data in it.
If I delete those rows, it messes up all the formulas on other pages. Is
there a way to define the formulas such that deleting data won't change them?
I've tried using absolute cell references ($A$5), but when I delete the line,
this cell reference gets changed.
Thanks,
Pete
.
.
|