I have a formula in a cell at the top of the worksheet, which calculates
values of numbers below it (formula = G3*G8). However, I am constantly
adding rows below this formula with data into row G8, and as a result, the
formula changes to =G3*G9 which is no longer correct. I have tried placing $
in front of both the G and the 8 however it does not keep the cell constant.
Is there any way I can keep that cell constant while still adding rows below
it? Thanks for your help.