Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 26th 06, 03:15 PM posted to microsoft.public.excel.newusers
fwburkey
 
Posts: n/a
Default 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.


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


  #2   Report Post  
Old January 26th 06, 04:44 PM posted to microsoft.public.excel.newusers
tony h
 
Posts: n/a
Default 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

  #3   Report Post  
Old January 27th 06, 12:46 PM posted to microsoft.public.excel.newusers
fwburkey
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge and sort two pages RD Wirr Excel Worksheet Functions 3 January 13th 06 01:34 AM
Merge and sort pages of data RD Wirr Excel Worksheet Functions 2 December 21st 05 06:38 AM
Merge pages of data RD Wirr Excel Worksheet Functions 2 December 12th 05 05:09 AM
how to insert page numbering in an excel cell Kevin Excel Discussion (Misc queries) 0 November 16th 05 09:45 PM
creating 1 linked page from 26 pages Klaus A. Excel Discussion (Misc queries) 0 May 11th 05 05:52 PM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017