View Single Post
  #3   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?RXJpYw==?=,

There are two separate tables on my document and there is a total field
(=sum(above)) at the last row of the first table. I want to also show that
total value of the first table at the first row of the second table. Because
there is another calculation on the second table.
Can I add a field at the first row of the second table to refresh the value
from the first table? How?

Yes. It's described in the Help files...

"To reference cells in another table, or to reference a cell from outside a
table, identify the table with a bookmark. For example, the field {
=average(Table2 b:b) } averages column B in the table marked by the bookmark
Table2."

What this doesn't tell you is:
- You need to select the entire table, then Insert/Bookmark and type in the
bookmark name (Table2, for example)
- This only works when you use the bookmark in a FUNCTION. If you only want
to show the result of a single cell, you still need to do something like
{ = SUM(Table1 A1:A1) }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :-)