Thread: copying rows containing formulas

Hi all,

can anyone help with this...

I have a row with cells that contain formula, to work with in that row, and also in the formula, is a reference cell that is not located within that row,

I want to replicate this row down the sheet, so I have another calculator, that performs the equation within a different row,

when I copy everything down to the next row, it also pulls the reference cell down a row, is there any way I can copy this down rows, updating everything to the new row, while maintaining the reference cell.

Thanks for any assistance.

You use $ symbols to lock a part of a cell reference and keep it from changing. Anything that is left relative will change when copied, anything locked with a $ symbol is absolute and will not change.

A1 - relative column, relative row
$A1 - absolute column, relative row
A$1 - relative column, absolute row
$A$1 - absolute column, absolute row

Hi Thanks,

I have seen the $ symbol you are descibing, and I ampretty sure I understand what you are saying, I will try it when I get a chance, if I have any issues, I will post an example.

I will go through my script and add $ symbol to the cell I would like to keep as an absolute reference,

if for example, written in my formula, C11 is the cell I want to keep as absolute, is there any way to run a auto - find and insert function.

Thanks,

FIND: C11
REPLACE: $C$11

LOOK IN: Formulas

Excellent, thanks, for the sake of sounding dumb.... where I would enter that....

1) Highlight the cells to adjust
2) Press CTRL-H

Thank you all very much for this assistance, this has worked perfectly : - )