This is sort've a "reverse absolute cell references" question.
I have a formula that references, say, cell F9.
I instert a row, the info moves to row 10, and the formula updates to F10.
I don't want it to do that. I will put new info in row 9, and I want the original formula to continue to work with the info in F9
$-signs in the formula won't do the trick. Is there any way to make the cell reference constant regardless of where the current cell content goes?
Thanks,
--PS
I have a formula that references, say, cell F9.
I instert a row, the info moves to row 10, and the formula updates to F10.
I don't want it to do that. I will put new info in row 9, and I want the original formula to continue to work with the info in F9
$-signs in the formula won't do the trick. Is there any way to make the cell reference constant regardless of where the current cell content goes?
Thanks,
--PS