cell reference question
Hi: I have a data range starting in row 9 (colums A through K) that grows
each month by inserting about 50 new rows directly between row 9 and row 10.
I'm having trouble figuring out a way to write a formula on an adjacent
worksheet that permanently references cells C10: C30 despite new rows being
inserted. (i.e. whether I use absolute or relative references, once I insert
50 new rows above row 10, the formulae then reference C60:C80).
Is there any method/mechanism to do this????
Thanks SO much!
Marika :)
|