How do I reference a cell in one table and place it in another?

E

EchoGreg

I would like to do in Word what I do in Excel, use a formula to reference
information in a cell in one place and put it in another cell (e.g. If the
information in Table1, cell A2 is "Great", I want the word "Great" to appear
in Table2 in cell A1. In Excel, the formula would simply be "=Table1:A2".
What is the procedure in Word? Thanks.
 
D

Dawn Crosier, Word MVP

The easiest method is to bookmark the cell text and then create a
cross-reference to it in the second table. Otherwise you are going to
need a VBA solution as near as I can tell.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.




I would like to do in Word what I do in Excel, use a formula to reference
information in a cell in one place and put it in another cell (e.g. If the
information in Table1, cell A2 is "Great", I want the word "Great" to appear
in Table2 in cell A1. In Excel, the formula would simply be "=Table1:A2".
What is the procedure in Word? Thanks.


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.19/1258 - Release Date:
2/4/2008 10:10 AM
 
H

Henk57

Dawn said:
The easiest method is to bookmark the cell text and then create a
cross-reference to it in the second table. Otherwise you are going to
need a VBA solution as near as I can tell.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and
questions
to the newsgroup so that others can learn as well.




"EchoGreg" (e-mail address removed) wrote in message
-
I would like to do in Word what I do in Excel, use a formula to
reference
information in a cell in one place and put it in another cell (e.g. If
the
information in Table1, cell A2 is "Great", I want the word "Great" to
appear
in Table2 in cell A1. In Excel, the formula would simply be
"=Table1:A2".
What is the procedure in Word? Thanks.-


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.19/1258 - Release Date:
2/4/2008 10:10 AM

As an alternative solution to Dawn's, you can copy the text from the
source cell in Table 1 and paste it "As link" (via Edit/Paste
Special..) in the destination cell in Table 2. The contents are then
linked: changes in the source cell are also reflected in the
destination cell. This method works similar as dynamically linking to
Excel cells.
As an additional remark, I suggest to show Field shading as "Always" so
the destination cell shows as a field (with a gray background) to remind
you not to overwrite this value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top