Need macro to fill the values in msword based on the excel sheet info

macropod · #1 08-13-2018, 01:33 AM

In your first post, you said:

Quote:

Originally Posted by ganesang

i am not able to find to fill values from the drop-down in ms-word based on the excel sheet info's.

Here i have attached the both word and excel sheet needs to be fill values in ms-word from excel sheet.

Having looked at both your document and the workbook, it's not apparent any dropdown values are being filled - what you seem to want is a dropdown display name selected. Furthermore, it's not apparent why, if all you want is a set of fields in the document to be populated from an Excel workbook, you wouldn't do the lot via a mailmerge.

ganesang · #2 08-13-2018, 02:23 AM

Thanks for the reply Paul

Is there any options to select from the drop-down based on the workbook values...

For ex., in excel "Difficulty Level" is "Esy", in the word to be filled from the drop-down to "1-Easy" etc...

Please advise.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need macro to fill data from different sheets based on selected item from drop down	skorasika	Excel Programming	1	03-13-2015 11:25 AM
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet.	rogcar75	Excel	0	08-12-2014 07:21 AM
Color-fill a range of cells, based on text in a different sheet. Possible?	unittwentyfive	Excel	2	06-01-2014 06:48 AM
link conditional info in word based on excel list	stijnvanhoof	Mail Merge	1	11-13-2012 01:55 PM
Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248	Joe Patrick	Word VBA	2	01-30-2012 07:23 AM