+ Reply to Thread
Results 1 to 3 of 3

create dynamic drop down list for large list of data

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    create dynamic drop down list for large list of data

    I hope so one can help me out. I know how to create a drop down list, and I know how to do it so that as a person types the list will search and find what they are looking for..

    But my problem is it seems it doesn't work with a large group of Data, when to me that is when it is most useful.
    I have a list of over 40,000 parts. However when i create the dropdown list..it will not do the search..I have to type the full name of the part in..That kinda defeat the purpose.. Anyone have any ideas.
    here is how i been creating the list.

    I would sort the list in alphabetical order, then highlight all the table and give it a name in the name box.
    then i would hide all the rows of list of data.
    Then just below the list i would select the cell go to validation = allow list, source = name of list.
    this create the drop down list, and also allow you to do the typing and search feature as well.

    Any suggestion of a better way of doing it? that does not include VBA or using any control boxes.
    Oh and the list has more list where as they search and choose the part, it also populates the cost and price.


    Thanks for any help you can offer

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    27,175

    Re: create dynamic drop down list for large list of data

    It's about to rain here, so I thought I'd have a go at this. It looked like a useful thing to know. However, i quickly found this, elsewhere on the Forum. Does this do what you want?

    http://www.excelforum.com/excel-prog...down-list.html
    Last edited by Glenn Kennedy; 05-10-2014 at 04:40 AM.
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    27,175

    Re: create dynamic drop down list for large list of data

    Actually, this is better... I set it up in a couple of minutes.

    Here's the link:

    http://www.contextures.com/xlDataVal10.html

    I've attached the one that I made using these instructions...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create a dependent drop down list with dynamic list
    By JSmith1504 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 09:15 AM
  2. Help! Create Large Data List from two worksheets
    By mauricioaglr in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 01-22-2014, 08:25 PM
  3. Way to create a dynamic drop down list.
    By jensca in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 10:55 AM
  4. [SOLVED] Create new list based on data from another dynamic list
    By y_not in forum Excel General
    Replies: 6
    Last Post: 01-04-2013, 09:16 AM
  5. create a dynamic drop down list based on specific criteria
    By stevegrobertson in forum Excel General
    Replies: 4
    Last Post: 02-21-2012, 08:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1