exporting data from excel into word

Hello pboost1,

I didn't change the drop down boxes as they were part of the original form you sent me. It seemed more logical to have a single drop down for the Form Numbers and auto-fill the remaining sections. The other fields can be changed to auto-filled, but that means I will need to alter the macro as well. If that is what you want to do, I will need some time to make those changes. Let me know.

Sincerely,
Leith Ross

Yes, please. I would like to be able to enter the one data form number and have everything else autofill. If that could be done, that would be great. Thanks.

Hello pboost1,

The attached Word document has been amended. It will now auto-fill the text on the template when you select a form number.

Sincerely,
Leith Ross

The sample works great. I thank you very much. I just need to adapt what you have given to what I have at work. Thank you again.

Would you be willing to explain how you did this? If you don't want to or feel comfortable, I definitely understand. You have helped out a lot with all that you have done. Thank you again.

Have you tried to do a merge file from word using the excel file fields?

I am not sure how to do a merge file or what it is. Could you please elaborate as to what this is and how to do it?