A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

copying formula cells



 
 
Thread Tools Display Modes
  #1  
Old September 14th, 2006, 08:27 PM posted to microsoft.public.word.tables
Tex Shalter
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  
Old September 15th, 2006, 10:26 AM posted to microsoft.public.word.tables
Cindy M.
external usenet poster
 
Posts: 2,428
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  
Old September 15th, 2006, 03:09 PM posted to microsoft.public.word.tables
Tex Shalter
external usenet poster
 
Posts: 12
Default copying formula cells

Thanks Cindy,

Will give it a try soon




  #4  
Old September 15th, 2006, 08:31 PM posted to microsoft.public.word.tables
Tex Shalter
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  
Old September 15th, 2006, 08:51 PM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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  
Old September 16th, 2006, 02:31 PM posted to microsoft.public.word.tables
Tex Shalter
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  
Old September 16th, 2006, 03:54 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
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  
Old September 16th, 2006, 04:02 PM posted to microsoft.public.word.tables
Cindy M.
external usenet poster
 
Posts: 2,428
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  
Old September 27th, 2006, 03:55 PM posted to microsoft.public.word.tables
Tex Shalter
external usenet poster
 
Posts: 12
Default copying formula cells

Thanks to both of you, got it working great !


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.