Filtering a Drop Down List

D

dch3

How can I filter the values listed in a drop down list based on values
present in another cell? As in....


  • Category Description
    Warehouse Warehouse 1
    Warehouse Warehouse 2
    Warehouse Warehouse 3
    Office Office 1
    Office Office 2

    [Worksheet]
    Category Description (Drop Down Filtered based on Category)
    Warehouse Warehouse 1
    Warehouse 2
    Warehouse 3
 
D

dch3

Within Access it is a somewhat common practice to alter the values in a drop
down box based on the selection made in another. Behind the scenes, this is
as simple as using the value in the first box in the WHERE portion of the SQL
statement that populates the second. So then, if I select 'HONDA' in the
first box, I only get 'HONDA' cars in the second.

Gord Dibben said:
What you are referring to is "dependent lists"

See Debra Dalgleish's site for how-to-do.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

How can I filter the values listed in a drop down list based on values
present in another cell? As in....


  • Category Description
    Warehouse Warehouse 1
    Warehouse Warehouse 2
    Warehouse Warehouse 3
    Office Office 1
    Office Office 2

    [Worksheet]
    Category Description (Drop Down Filtered based on Category)
    Warehouse Warehouse 1
    Warehouse 2
    Warehouse 3
Click to expand...
Click to expand...
 
Top