adding rows
How do I add rows without changing cell location in the formula.
For example:
The data for the formula is always located in cell B4 and if I
add a row on top of B4, I want the formula to remain with B4.
Right now, if I add a row, the cell in the formula goes down
one row.
Hope for help
|