copying formula cells "Tex Shalter" <anon.x[ at ]anon.invalid> 14.09.2006 19:27:50 I am trying to have a number appear a second time in a document to be derived from a formula in a table. for example, I have a table that shows a cell (sum left), I want to have this same sum appear in another table or page in a the document. And work with a field update Maybe it's not possible in word, Thanks to anyone

Re: copying formula cells Cindy M. <C.Meister-C[ at ]hispeed.ch> 15.09.2006 09:26:33 Hi Tex, [Quoted Text] > I am trying to have a number appear a second time in a document to be > derived from a formula in a table. > > for example, I have a table that shows a cell (sum left), I want to have > this same sum appear in another table or page in a the document. And work > with a field update > Select the field that performs the Sum calculation (just the field, not the entire cell). Insert/Bookmark and give it a name. Now you can use a REF field (or Insert/Cross-Reference) to pick up the bookmark's contents. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)

Re: copying formula cells "Tex Shalter" <anon.x[ at ]anon.invalid> 15.09.2006 14:09:00 Thanks Cindy, Will give it a try soon

Re: copying formula cells "Tex Shalter" <anon.x[ at ]anon.invalid> 15.09.2006 19:31:48 The "REF expenses" field appears (when showing field codes) but it doesn't show anything in the cell with field codes turned off, or when update fields run. "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message news:0uyOg.47119$QM6.34510[ at ]bgtnsc05-news.ops.worldnet.att.net... [Quoted Text] > Thanks Cindy, > > Will give it a try soon > > > >

Re: copying formula cells "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 15.09.2006 19:51:00 When you have the display of bookmarks activated (Tools>Options>View) what appears inside the markers of the bookmark that is referenced by the REF field. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message news:EcDOg.149457$5i3.142574[ at ]bgtnsc04-news.ops.worldnet.att.net... [Quoted Text] > The "REF expenses" field appears (when showing field codes) but it doesn't > show anything in the cell with field codes turned off, or when update > fields > run. > > "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message > news:0uyOg.47119$QM6.34510[ at ]bgtnsc05-news.ops.worldnet.att.net... >> Thanks Cindy, >> >> Will give it a try soon >> >> >> >> > >

Re: copying formula cells "Tex Shalter" <anon.x[ at ]anon.invalid> 16.09.2006 13:31:10 Hey Doug, It displays a grey "I" in front of the number in the cell [Quoted Text] > When you have the display of bookmarks activated (Tools>Options>View) what > appears inside the markers of the bookmark that is referenced by the REF > field. > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message > news:EcDOg.149457$5i3.142574[ at ]bgtnsc04-news.ops.worldnet.att.net... > > The "REF expenses" field appears (when showing field codes) but it doesn't > > show anything in the cell with field codes turned off, or when update > > fields > > run. > > > > "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message > > news:0uyOg.47119$QM6.34510[ at ]bgtnsc05-news.ops.worldnet.att.net... > >> Thanks Cindy, > >> > >> Will give it a try soon > >> > >> > >> > >> > > > > > >

Re: copying formula cells "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> 16.09.2006 14:54:38 The grey I indicates a single-point bookmark. You need to select the contents of the cell and bookmark the whole thing. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message news:y0TOg.155904$5i3.114749[ at ]bgtnsc04-news.ops.worldnet.att.net... [Quoted Text] > > Hey Doug, > It displays a grey "I" in front of the number in the cell > > > When you have the display of bookmarks activated (Tools>Options>View) what > > appears inside the markers of the bookmark that is referenced by the REF > > field. > > > > -- > > Hope this helps. > > > > Please reply to the newsgroup unless you wish to avail yourself of my > > services on a paid consulting basis. > > > > Doug Robbins - Word MVP > > > > "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message > > news:EcDOg.149457$5i3.142574[ at ]bgtnsc04-news.ops.worldnet.att.net... > > > The "REF expenses" field appears (when showing field codes) but it > doesn't > > > show anything in the cell with field codes turned off, or when update > > > fields > > > run. > > > > > > "Tex Shalter" <anon.x[ at ]anon.invalid> wrote in message > > > news:0uyOg.47119$QM6.34510[ at ]bgtnsc05-news.ops.worldnet.att.net... > > >> Thanks Cindy, > > >> > > >> Will give it a try soon > > >> > > >> > > >> > > >> > > > > > > > > > > > >

Re: copying formula cells Cindy M. <C.Meister-C[ at ]hispeed.ch> 16.09.2006 15:02:51 Hi Tex, [Quoted Text] > It displays a grey "I" in front of the number in the cell > Select the entire number, then Insert/Bookmark again, giving it the same name. If there's just a grey "I" in front, it means you didn't follow my instructions exactly: "Select the field that performs the Sum calculation (just the field, not the entire cell). Insert/Bookmark and give it a name." The bookmark needs to CONTAIN the information, it needs to look like [this]: square brackets around the information. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)

Re: copying formula cells "Tex Shalter" <anon.x[ at ]anon.invalid> 27.09.2006 14:55:40 Thanks to both of you, got it working great !