"Shirley Munro"
wrote in message
news:Shirley.Munro.22lnfm_1138879501.0748@excelfor um-nospam.com...

I am having problems copying a formula which contains a link to another
worksheet in the same workbook. One worksheet contains figures that
need to be copied into another worksheet for the purpose of this
question I have called it Sheet 1. The first figure to be copied is in
cell D3, the next figure in cell F3, the next figure in cell H3 and so
on. The second sheet wants to create a formula which brings in the
figures from Sheet 1 starting in column B, cell 3 and then continuing
down column B. The first formula I have entered is ='Sheet1'!D$3, the
second formula I have entered is ='Sheet1'!F$3. I now select the 2
cells containing the formula and when I copy this down I want it to
become 'Sheet1!H$3, 'Sheet1'!J$3, 'Sheet1'!L$3, 'Sheet1'!N$3 etc but
this isn't happening. Instead I just keep getting ='Sheet1'!D$3 and
='Sheet1'!F$3 repeated down the column.

If you are trying to refer from alternate columns in your data sheet & pick
them up in consecutive rows in your second sheet starting from cell B3, you
may be easier using a formula like:
=OFFSET(Sheet1!D$3,0,(ROW()-3)*2)
--
David Biddulph