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 :)