insert text to different pages and update
 

Is there a way to insert a text cell from one page put into another page
and when the first page cell is updated the second page cell will also
be updated. Using the = sign just displays the formula, not the text.
:confused:

Thanks
Frank


--
fwburkey
------------------------------------------------------------------------
fwburkey's Profile: http://www.excelforum.com/member.php...o&userid=30314
View this thread: http://www.excelforum.com/showthread...hreadid=505331

insert text to different pages and update
 

Not clear what you are doing wrong. the formula should look like
=Sheet1!A1 Make sure there is nothing to the left of the equals.

Unless in the Tools/options/view you have display formulas ticked.

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=505331

insert text to different pages and update
 

Tony, Thanks for the help, What i didn't mention is that i was doing
this with 2 merged cells, I got it to work by unmerging the cells,
retyping the text and than remerging the cells.

thanks again
frank


--
fwburkey
------------------------------------------------------------------------
fwburkey's Profile: http://www.excelforum.com/member.php...o&userid=30314
View this thread: http://www.excelforum.com/showthread...hreadid=505331