Thread: Filtering a Drop Down List

How can I filter the values listed in a drop down list based on values
present in another cell? As in....
[List]
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

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

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

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

XL2002, WinXP


"dch3" wrote:

> How can I filter the values listed in a drop down list based on values
> present in another cell? As in....
>
>[List]
> 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

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

On Mon, 31 Jul 2006 13:29:02 -0700, dch3 <dch3@discussions.microsoft.com> wrote:

>How can I filter the values listed in a drop down list based on values
>present in another cell? As in....
>
>[List]
>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

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" wrote:

> 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
>
> On Mon, 31 Jul 2006 13:29:02 -0700, dch3 <dch3@discussions.microsoft.com> wrote:
>
> >How can I filter the values listed in a drop down list based on values
> >present in another cell? As in....
> >
> >[List]
> >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
>
>