Filtering a Drop Down List

[Guest]

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

 

[Guest]

See the instructions for Dependent Lists at Debra Dalgleish's website:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Gord Dibben]

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

 

[Guest]

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.

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