HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO.
 

I want to copy a cell that has a reference to a cell in another sheet but I
want the new reference to be incremented by 2 positions.
example copy cell f1 to f2, cell f1 has a reference to 'test'!r5
I want the f2 cell to reference 'test'!r7
Can this be done?

Thanks,

no1crusty

HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO.
 

Hi

Try
=INDIRECT("'Test'!R"&5+(ROW(A1)-ROW($A$1))*2)

--
Regards

Roger Govier


"Crusty" wrote in message
...
I want to copy a cell that has a reference to a cell in another sheet
but I
want the new reference to be incremented by 2 positions.
example copy cell f1 to f2, cell f1 has a reference to 'test'!r5
I want the f2 cell to reference 'test'!r7
Can this be done?

Thanks,

no1crusty