Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2007
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I want users to be able to see a list of items based on a selection they make from a drop down list.

    Example:

    Category Item
    Fruit Apple
    Fruit Banana
    Fruit Peach
    Vegetable Carrot
    Vegetable Celery
    Vegetable Spinach
    Meat Beef
    Meat Lamb

    If the user selects Fruit from a drop down list, I want a list of the items in that category to display.

    Any ideas?

    Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts
    [quote name='cemac' post='775389' date='15-May-2009 11:16']I want users to be able to see a list of items based on a selection they make from a drop down list.[/quote]
    See if the link in Steve's Post 756875 is what you want.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    [quote name='cemac' post='775389' date='15-May-2009 18:16']I want users to be able to see a list of items based on a selection they make from a drop down list.
    ...
    If the user selects Fruit from a drop down list, I want a list of the items in that category to display.[/quote]
    Have a look at Rory's very elegant solution in Post 769688 (with more detailed explanation in Post 769859)

  4. #4
    Lounger
    Join Date
    Mar 2009
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='cemac' date='15-May-2009 13:16' post='775389']
    I want users to be able to see a list of items based on a selection they make from a drop down list.

    There is a good article here

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    [quote name='mdmackillop' post='775448' date='16-May-2009 10:58'][/quote]
    The article you referenced is the same one as pointed to by John's post.

    I think that the code in Rory's post that I referenced is much better because it greatly simplifies the Data Validation lists. The first validation list is across a row, and the dependent lists simply sit in the columns below the first list. The only named range is the list used for validating the first drop down. Everything else is calculated using worksheet functions.

Posting Permissions

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