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

By david66lewis ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums