Copying a formula to column using a value from a particular cell
 

I wish to copy a formula to a number of rows in a column using a value from a
particular cell in each formula. What is happening is that when I paste the
copied formula the reference to the cell with the value I wish to use is
moved down with the other cell references.

Copying a formula to column using a value from a particular cell
 

If you use absolute references then it should do what you want. For example

=$A$2*6

will always reference cell A2 no matter where it is copied to.

Mike

"effnbee" wrote:

I wish to copy a formula to a number of rows in a column using a value from a
particular cell in each formula. What is happening is that when I paste the
copied formula the reference to the cell with the value I wish to use is
moved down with the other cell references.

Copying a formula to column using a value from a particular ce
 

Thanks Mike, a great help, so simple when you know how
Cheers