Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge and sort two pages | Excel Worksheet Functions | |||
Merge and sort pages of data | Excel Worksheet Functions | |||
Merge pages of data | Excel Worksheet Functions | |||
how to insert page numbering in an excel cell | Excel Discussion (Misc queries) | |||
creating 1 linked page from 26 pages | Excel Discussion (Misc queries) |