Hi


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.

Any suggestions would be appreciated.

Shirley Munro


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=507595