Copying a formula "literally"
Max,
If you place a $ in front of the column reference (i.e. +$D1), it will
always keep your cell reference on column D. The same thing applies to
rows if you place a $ in front of the row reference (i.e. +D$1). You
can also have a static cell reference by placing a $ in front of both
the column and row reference (i.e. +$D$1). In addition, you can copy
the cells with the formula you need and Paste Special -- Formulas
where you want the new formulas.
I hope that helps!
Jan
|