Fields that reference other fields

V

vschneider

In Excel if I put +B13 in cell A10 the data in cell B13 appears in cell A10.
When the data in cell B13 changes so does the data displayed in cell A10.
How do I do something like this in Word? I've created a document with 5
tables in it. Each table has a column of numbers with the last row being a
sub total. In the last table is a summary of the previous tables. I want
the summary table to automatically update the final totals whenever I change
a value in one of the previous tables. The previous tables use the
=SUM(ABOVE) formula to automatically sum (once you press update fields) the
data in the rows above the formula, but I haven't found a way to "copy" that
data as an active reference in the finals table. Help?
 
J

Jay Freedman

In Excel if I put +B13 in cell A10 the data in cell B13 appears in cell A10.
When the data in cell B13 changes so does the data displayed in cell A10.
How do I do something like this in Word? I've created a document with 5
tables in it. Each table has a column of numbers with the last row being a
sub total. In the last table is a summary of the previous tables. I want
the summary table to automatically update the final totals whenever I change
a value in one of the previous tables. The previous tables use the
=SUM(ABOVE) formula to automatically sum (once you press update fields) the
data in the rows above the formula, but I haven't found a way to "copy" that
data as an active reference in the finals table. Help?

See http://gregmaxey.mvps.org/Repeating_Data.htm
 

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