How can I auto-fill a word document by matching data in an excel document?

I have a word document with several lines for different entries. I want the operator of the form to enter a value (userID) and have the word document auto-fill the other values on the form based on the corresponding values from an excel spreadsheet. After the values are updated, the user should be able to override them on the word document (not changing the excel spreadsheet.

) Where can I find VB code to do this, what other avenues are available for the same result? I am limited to the Microsoft office suite (word, excel, access) and VBA scripts. Asked by ac7ss 37 months ago Similar questions: auto fill word document matching data excel Computers > Hardware > Desktops & Laptops.

Similar questions: auto fill word document matching data excel.

Microsoft Word Mail Merge If I understood correctly what you need to do then you can use Word Feature "Mail Merge". It is pretty simple to use. Good Luck..

1 Start with the Vlook up function in excel and loading fields in the doc. Though a macro may be the answer try to avoid this if possibeAs you want to use Excel and Word you should use VBA not VB .

Start with the Vlook up function in excel and loading fields in the doc. Though a macro may be the answer try to avoid this if possibeAs you want to use Excel and Word you should use VBA not VB.

" "How to Export data to Excel . Net" "I know uninterrupted power suppies (UPS) are good for desktops...should people have one for laptops, too?" "how can it turn pdf files into word document" "Linking in a Word document.

I am trying to do someting in Microsoft Excel and I need help with it... I am making a document with several worksheets.

How can it turn pdf files into word document.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.