D
Derek M
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
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