Hello I have a problem with linking my worksheets.

I have a set of seven worksheets that contain specific data and on the
eighth worksheet I want somewhat of a summary sheet. I am trying to
link the cells from the specific sheets to the summary sheet.

I am using a point and click method of doing this (click on the target
cell, press "=" and then click the target cell from another worksheet
and hit enter). This worked properly for all of the fields containing
numeric data, but the fields that have text data do not copy over they
just display the string of link, not the actual link value itself.

For example I have ='W&Ww 1'!B7 but instead of returning the proper
strign value it returns ='W&Ww 1'!B7 in the cell.

I have tried cell formatting but can't make it work, what is going on
here?


--
MarkGG
------------------------------------------------------------------------
MarkGG's Profile: http://www.excelforum.com/member.php...o&userid=26342
View this thread: http://www.excelforum.com/showthread...hreadid=396091