Hi

When i paste special from one cell into another, it advances the cell
reference and i just want an exact match i.e.

A1 formula ='Feb 2010'!C18 but when i paste it into another cell it pastes
it as
='Feb 2010'!D18

The C changes to D, how do i stop this happening?

Thanks for any help in advance

Derek

Use absolute referencing. Below are the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

--
Jacob (MVP - Excel)


"Derek M" wrote:

Hi

When i paste special from one cell into another, it advances the cell
reference and i just want an exact match i.e.

A1 formula ='Feb 2010'!C18 but when i paste it into another cell it pastes
it as
='Feb 2010'!D18

The C changes to D, how do i stop this happening?

Thanks for any help in advance

Derek

Put a $ before and after the C to lock it



"Derek M" wrote:

Hi

When i paste special from one cell into another, it advances the cell
reference and i just want an exact match i.e.

A1 formula ='Feb 2010'!C18 but when i paste it into another cell it pastes
it as
='Feb 2010'!D18

The C changes to D, how do i stop this happening?

Thanks for any help in advance

Derek