Shirley -- if you copy down it changes the rows not the columns.
I think I have a way arouinf this... if you take yourformulas copy them
across columns it will change the calues to "=Sheet1!B$1", "=Sheet1!C$1" etc.
thna if you replace all "=Sheet1" with "Sheet 1", copy and paste the values
to the column you want, use paste special and "Transpose" this will take the
columns and put them in a row. Then redo your replace "Sheet1" to "=Sheet1"
all should be well.

I tried to do this without replacing the formulas, but iot still changes
them to B1, B2. etc.

hope this helps
wAyne

"Shirley Munro" wrote:


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