WORD - updating multiple items with the same data

[adrianlewis]

Any help with this would be great.

I have a Word document which is a letter that contains calculations.

At the moment I have to manually enter in all the values for the calculations which kinda look like...

Your offer is £XXXXXX

This is made up from...
£XXXXXX + £XXXXXX = £XXXXXX

Basically I want it so that when the value for offer is entered the second value in red is automatically completed with the same amount.

Unsure if this needs to be done using vba or a simpler function already built into word such as fields or bookmarks etc. being trying but not getting anywhere. Any help with this would be great. Thanks in anticipation.

Adrian

[PMich]

The only way I know how to do that in word is with a table. You can create a table with your components in the first x columns and then select the cell in the last column and click table > formula and enter =sum(left) in the formula field of the popup window.

[Cheryl]

You can do it using fields, but you will need to make it as a template. Click view > toolbars > forms (if the forms toolbar isn't already visible). The first button on the toolbar is a text field. Put your curser where you want the first numbers and double click the text field button. Then double click the field so the properties box comes up & give it a name (i.e., value1) and format it if you want. Insert the second field where you want it, double click the field, give it a name, format, etc. & check "calculate on exit". Put your cursor where you want the total & then click insert > field > and click the "formula button". Type in box after the "=" value1+value2 (no spaces) (or whatever names you used). Add that field again the same way in the second place you want it. You will need to insert text fields whereever you want to add text that is not a standard part of your letter. When your done inserting the fields, you have to lock it (the last button on the forms toolbar) in order to enter the info in the text boxes. Hope this is not too confusing

Cheryl

[adrianlewis]

Absolute star

Just what I needed and it works perfectly.

Thanks for your help. owe you one