Populate Word Drop-down list with Excel column then auto fill form fields with Excel data
Hi,
I need to auto populate a drop down list with Excel data for example, Column A in 'data.xlsx'. Which I have managed to do by searching the forum and finding a macro to do it.
I now need other form fields to populate based on the selection in the drop down list.
I am not an expert in Word as my experience is based more in Excel.
I basically need the Word template to do a VLOOKUP based on what the user selects in the first drop down box, then populate about 5 other fields automatically.
Any help would be much appreciated. If giving advice, please remember that I'm not an expert in Word so may need more detailed instructions!
Mark
|