Hi,
I have a Word Document with 2 Tables in it, and I use Fields within Both.
I want to use Table 1 to show the Totals from the Data in Table 2.
eg: In Table 2:
-------------------
| Chocolate | £1.59 |
|-----------|-------|
| Cola | £2.50 |
|-----------|-------|
| Gum | £0.59 |
-------------------
Table 1:
----------------
| Sweets | £2.18 |
|----------------|
| Drinks | £2.50 |
----------------
So I would like is a formula that will:
Add Table 2 B1 + Table 2 B3
Formula: {=T2:B1 + T2:B3 \# "£#,##0.00;(£#,##0.00)"}
Insert Table 2 B2
Formula: {T2:B2 \# "£#,##0.00;(£#,##0.00)"}
I am not sure how you reference Table 2 in the code for Table 1?
Please note that if possible I would like to do this within the Fields without using VBA, so when I change the amounts in Table 2 and then I do a Print Preview or Print the Page, then the Totals in Table 1 will be updated for me.
Thank you in advance,
Neil