Having a Drop-down list in Word referring to an Excel list
Hello, brilliant people!
I wonder if this can be done:
I have a Word Template Document with several fields. In one of them, I want to have a drop-down list whose items are on an Excel File called "ClientList" - in Sheet1, column A. This list has more than 100 items.
Is it possible to automatically refer this drop-down list to that Excel list so that it is always updated, meaning that if any changes are made to the Excel file, the next time I open the Word template document, the list is complete and up-to-date?
I know very little of Macros and VBA but I am willing to learn. If this is something that you think you could teach me how to do, please remember that I am a newbie.
Thank you very much in advance for any help provided.
|