Hi,

I have two tables on an A4 sheet. Each table has four rows
and five columns.

Is it possible to have cell referencing between these
tables? In other words the value in cell R1C7 might refer
to a value in R1C1. Like Excel's referencing system =$A$3.

I've been trying to get this to work, but I'm struggling
to get it going.

Thanks for your help.

Adam

Hi SNurd,

I have two tables on an A4 sheet. Each table has four rows
and five columns.

Is it possible to have cell referencing between these
tables? In other words the value in cell R1C7 might refer
to a value in R1C1. Like Excel's referencing system =$A$3.

I've been trying to get this to work, but I'm struggling
to get it going.

It's possible, but the approach isn't intuitive.

Select the table you want to reference, then Insert/Bookmark.

Now, in the cells of the other table, you need to enter a
formula field. Assuming I assign the bookmark Tbl1 to the
source table, and want to display the content of the second
cell in the third row:
{ = Sum(Tbl1 B3:B3) }

Note that the content of the cell must be numerical,
otherwise the field will return a 0.

For non-numerical content, your only choice is to bookmark
the cell's content (only the text, not the entire cell), then
cross-reference that bookmark.

Or, if it will work for the kind of document you're creating,
you could
- insert form fields in the source table
- insert a section break after (or before and after) this
table
- use cross-references to display the form fields'
content (a form field name is a bookmark)
- protect the document as a form, protecting only the
section with the form fields.

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