Use Excel 2010 table to populate Word 2010 template drop down list (VBA) - TechRepublic
Question
February 5, 2018 at 03:50 AM
david66lewis

Use Excel 2010 table to populate Word 2010 template drop down list (VBA)

by david66lewis . Updated 8 years, 4 months ago

Dear Community,

I have an Excel spread sheet with information about medical practices (name, address, telephone etc) and what we call a “Blitz Form” word template used to capture data from each practice I visit. Most practices are already listed with their deets in a specific spreadsheet table. I want to use the values in that table to populate drop down lists in my Blitz form template; I’m not certain the best way to accomplish this task.
Blitz forms are kept in a folder structure (the template in a seperate folder) – will references need to be relative in case they are moved from one folder to another?
I’m happy to read existing tutorials, those I’ve found in searches don’t quite accomplish this effectively.
Any pointer would be truly appreciated.

David Lewis

This discussion is locked

All Comments