Population of pull down fields via data from Excel file
Posted on 2011-05-11
We are using MS Office 2007. To connect/link excel files with other excel files to pull data is quite known and easy to realize. We have an excel file on the server which does contain a lot of "basic" information which is used constantly and allover in various other excel files and word files.
This are e.g. certain abbreviations, employee names etc.
In order to improve standardization, reduce spelling mistakes and work I'm in the process to link different files with the "coding" file. In terms of Excel it works fine but how I can populate pull down fields in Word forms with data stored in columns in Excel?
How to make sure that word is pulling last valid data in alphabetical order and without duplicates into the pull down fields upon opening?
Looking for an add in or existing but hidden function, macro etc. to realize that task. Depending on the MS Word form I would need to populate one up to 5 different pull down field with data all located in one and the same excel file but partly in different sheets.
Looking forward to get help here. I have only very basic VBA knowledge, thank you in advance for keeping this in mind.