How to link cells within a word table

I am creating a report in Word. This report is linked to a database and data is written to cells in the table automatically.
However some of the cells within the table will need to be manually filled by the user. These cells appear in several places within the report and I want the user to only have to type it once and for it to be filled in automatically in the other cells.
How can this be done, linking cells together in a Word table? I know it could be done easily enough in Excel but I need to use Word for this report.
 
cah00tsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
If the first occurence is bookmarked, repeat displays can be done with Ref fields which point to the bookmark. Update the fields in the document so:  use  Ctrl+A  to select the whole document and then F9 to update all fields in the selection.
0
cah00tsAuthor Commented:
Thanks for the response. But I don't want the users to have to Ctrl A and then F9, as they wouldn't be able to find F9. Is there any other way whereby the fields would be filled automatically and any chnges to the fields would update automatically?
0
GrahamSkanRetiredCommented:
You would have to update fields or run some VBA. Whichever method is chosen, the problem comes in initiating the action. It might be acceptable to delay the update until printing, when it is done automatically (if the option is set).
 
Otherwise the only way to trigger field updating without the user doing something special is to use FormFields, and have 'Calculate on exit' ticked in the Properties. This of course means that at least part of the document must be protected and that brings some major limitations (e.g. no spell checking), which might be unacceptable.

If you are able to consider using VBA, then perhaps a UserForm could be used to gather the information, before loading it down to the document. You could then either have each display location bookmarked and load the data with VBA, or you could still use the Ref fields and update the fields programatically (ActiveDocument.Fields.Update)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.