Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Tex Shalter Tex Shalter is offline
external usenet poster
 
Posts: 12
Default copying formula cells

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




  #2   Report Post  
Posted to microsoft.public.word.tables
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default copying formula cells

Hi Tex,

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 :-)

  #3   Report Post  
Posted to microsoft.public.word.tables
Tex Shalter Tex Shalter is offline
external usenet poster
 
Posts: 12
Default copying formula cells

Thanks Cindy,

Will give it a try soon




  #4   Report Post  
Posted to microsoft.public.word.tables
Tex Shalter Tex Shalter is offline
external usenet poster
 
Posts: 12
Default copying formula cells

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" wrote in message
...
Thanks Cindy,

Will give it a try soon






  #5   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default copying formula cells

When you have the display of bookmarks activated (ToolsOptionsView) 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" wrote in message
...
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" wrote in message
...
Thanks Cindy,

Will give it a try soon










  #6   Report Post  
Posted to microsoft.public.word.tables
Tex Shalter Tex Shalter is offline
external usenet poster
 
Posts: 12
Default copying formula cells


Hey Doug,
It displays a grey "I" in front of the number in the cell

When you have the display of bookmarks activated (ToolsOptionsView) 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" wrote in message
...
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" wrote in message
...
Thanks Cindy,

Will give it a try soon










  #7   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default copying formula cells

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" wrote in message
...

Hey Doug,
It displays a grey "I" in front of the number in the cell

When you have the display of bookmarks activated (ToolsOptionsView)

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" wrote in message
...
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" wrote in message
...
Thanks Cindy,

Will give it a try soon











  #8   Report Post  
Posted to microsoft.public.word.tables
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default copying formula cells

Hi Tex,

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
:-)

  #9   Report Post  
Posted to microsoft.public.word.tables
Tex Shalter Tex Shalter is offline
external usenet poster
 
Posts: 12
Default copying formula cells

Thanks to both of you, got it working great !


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I want text from the cells in one table repeated in other tables Reg Tables 2 February 14th 06 01:53 PM
cell's background color not printed correctly [email protected] Tables 2 December 19th 05 12:44 PM
Copying cells in template Megh Microsoft Word Help 1 November 10th 05 04:21 PM
Formula to Sum values in word table Craig Mailmerge 1 August 29th 05 06:19 PM
Formula in table - Creating a final total from sub-total cells Anne Gilmour Tables 1 November 7th 04 04:14 AM


All times are GMT +1. The time now is 02:28 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"