Correction: I have added the correct/revised Word Template of what I am needing help with. I have highlighted in yellow the entry that I would like to have a drop down list for and once that entry is selected from the drop down the other fields will populate (I have bolded as shown below). This isn't the actual information but I just wanted to give a general idea of what the format of the template will be. I will be using over 400 client names to choose from along with its corresponding provider & client info and I am not sure if it would be best to use VBA and have the excel file as my source. Please help. Thanks again for responding.


- Guidelines for submitting information for your client Adair County (MO) and Provider Dell.
· Please complete applicable fields on the claim
· All information should be submitted for payment to the provider address: P.O. BOX 1234 MISSOULA, MONTANA 59806-1234
· Item Name: Click here to enter text. Item Control#: Click here to enter text.
· Client Address: 123 Bradshaw St. Louis, MO 12345
· Client Prefix: ARK
· Client Group Number: 790123

Attached Files

	Provider Template Test.docx (23.2 KB, 15 views)
	Providers.xlsx (12.8 KB, 13 views)