word 2003 how to pull data from excel table using drop down list



  • 1. Master Table Template
    Does anyone know if there is a function in Word (any version) that allows you to create a master table that when inputted with information automatically updates other tables and specified fields within a document? Or if this can be done in excel? Thanks Matt -- Gerrard29
  • 2. Copying Word 2000 Tables - URGENT
    I have a client who is trying to copy a formatted table from one Word 2000 document to another. When she pastes (regardless of whether she uses paste special or paste cells), the table loses its formatting. How can she paste the table and retain the formatting? All help is greatly appreciated. -- LPS
  • 3. rotating table used in word
    I am using Word 2002. I have a document that has several table. i have changed the orientation so that it is landscape but i need to rotate one of the tables. this is for a class I am doing - any suggestions.
  • 4. Word tables and bullets
    I need to know how to make 2 tablesand Hyperlinks and bullets? -- pip

word 2003 how to pull data from excel table using drop down list

Postby RGlhbW9uZEFpcmVz » Sun, 07 Oct 2007 03:24:02 GMT

How can I create a drop down menu that will pull specific data from an excel 
spreadsheet into an exisitng word 2003 document?

Thank you!

Re: word 2003 how to pull data from excel table using drop down list

Postby Doug Robbins - Word MVP » Sun, 07 Oct 2007 09:20:53 GMT

See the article "Load a ListBox from a Named Range in Excel using DAO" at:


Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Similar Threads:

1.Drop-down list on simple excel 2003 form using "form" from data me

I have 2 sheets, one with a list of company names for a drop down list
The second sheet has several columns, the first of which is the company name
In the fields under the company name column, I set up data validation and 
set it to look up from the first sheet (I named the list first) "CompanyList"

The drop down list works fine if entering from the worksheet itself.

But if I choose "form" from the "Data" menu, the basic form comes up with 
all the fields, but there is no drop down for the company field

I don't want to create a combo box or use VB programming, since this is a 
very simple lookup and doesn't require anything else to be filled in 

How do I get the drop down list to show on the Excel form?

2.using data in excel to create drop down lists in a word template

Can anyone tell me how I can go about taking named ranges I have in excel and 
utilizing them as drop down lists in word forms?  

3.Link Drop Down list with PIVOT Table in Excel 2003


I'm using MS Excel 2003 and need a solution regarding link my drop down list 
with my pivot table.

Query :
I have created a drop down list in which month can be selected and wanted to 
link with pivot table in which month wise team count is displayed for a 
selected month. Presently I'm drag n drop the month in pivot table and its 
shows the count. But this exercise I have to do every time when I need the 
Is it possible that I have select the month from my drop down list (created 
in same sheet) and pivot table shows the data related to that month.

Please help me.


4.Pull corresponding data from drop down list

I created a list of part numbers and prices on one worksheet,"PriceList" in 
two columns. (A=Name, B=$) On another worksheet "Configure", in the same 
workbook I have one cell that is a drop down list of the part names(P2).  I 
want the next cell over (Q2) to pull the corresponding price when I choose 
the part number from the list.  Thanks in advance for your assistance!

5.Pull down list - drop down arrow

Is it possible when using pull down lists to have the drop down arrow show
all the time, not only when the cell is selected?

6. Using drop-down list in Excel 2003

7. Single pull down list for multiple pull downs

8. Using a drop-down list along with an auto-populate drop-down

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 28 guest