Is there a way to narrow down data value selections for users based on input
criteria?

What I would like to do is have users select a value from column A, but then
in column B I want to narrow down their value list selection BASED on the
value they selected in column A.

For example, if users selected "Night" in column A, then I want "Bat",
"Owl", "Kinkajou" to be the only available values in column B for users to
select from. However, if they selected "Day" in Column A, then I want "Dog",
"Cat", "Horse" to be the only available values in Column B for users to
select from.

The goal is to narrow their selections down (based on their earlier value
selections) in order to avoid data entry mistakes.

Thanks, Mary-Lou

If you are using Data Validation, see
http://www.contextures.com/xlDataVal02.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MLK" <(E-Mail Removed)> wrote in message
news:FEB22EE1-93CD-4998-A238-(E-Mail Removed)...
> Is there a way to narrow down data value selections for users based on
> input
> criteria?
>
> What I would like to do is have users select a value from column A, but
> then
> in column B I want to narrow down their value list selection BASED on the
> value they selected in column A.
>
> For example, if users selected "Night" in column A, then I want "Bat",
> "Owl", "Kinkajou" to be the only available values in column B for users to
> select from. However, if they selected "Day" in Column A, then I want
> "Dog",
> "Cat", "Horse" to be the only available values in Column B for users to
> select from.
>
> The goal is to narrow their selections down (based on their earlier value
> selections) in order to avoid data entry mistakes.
>
> Thanks, Mary-Lou

See:

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

"MLK" wrote:

> Is there a way to narrow down data value selections for users based on input
> criteria?
>
> What I would like to do is have users select a value from column A, but then
> in column B I want to narrow down their value list selection BASED on the
> value they selected in column A.
>
> For example, if users selected "Night" in column A, then I want "Bat",
> "Owl", "Kinkajou" to be the only available values in column B for users to
> select from. However, if they selected "Day" in Column A, then I want "Dog",
> "Cat", "Horse" to be the only available values in Column B for users to
> select from.
>
> The goal is to narrow their selections down (based on their earlier value
> selections) in order to avoid data entry mistakes.
>
> Thanks, Mary-Lou

Thanks, that's it!

"Bob Phillips" wrote:

> If you are using Data Validation, see
> http://www.contextures.com/xlDataVal02.html
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "MLK" <(E-Mail Removed)> wrote in message
> news:FEB22EE1-93CD-4998-A238-(E-Mail Removed)...
> > Is there a way to narrow down data value selections for users based on
> > input
> > criteria?
> >
> > What I would like to do is have users select a value from column A, but
> > then
> > in column B I want to narrow down their value list selection BASED on the
> > value they selected in column A.
> >
> > For example, if users selected "Night" in column A, then I want "Bat",
> > "Owl", "Kinkajou" to be the only available values in column B for users to
> > select from. However, if they selected "Day" in Column A, then I want
> > "Dog",
> > "Cat", "Horse" to be the only available values in Column B for users to
> > select from.
> >
> > The goal is to narrow their selections down (based on their earlier value
> > selections) in order to avoid data entry mistakes.
> >
> > Thanks, Mary-Lou
>
>
>

This is what I'm looking for. Thanks.


"Toppers" wrote:

> See:
>
> http://www.contextures.com/xlDataVal02.html
>
> "MLK" wrote:
>
> > Is there a way to narrow down data value selections for users based on input
> > criteria?
> >
> > What I would like to do is have users select a value from column A, but then
> > in column B I want to narrow down their value list selection BASED on the
> > value they selected in column A.
> >
> > For example, if users selected "Night" in column A, then I want "Bat",
> > "Owl", "Kinkajou" to be the only available values in column B for users to
> > select from. However, if they selected "Day" in Column A, then I want "Dog",
> > "Cat", "Horse" to be the only available values in Column B for users to
> > select from.
> >
> > The goal is to narrow their selections down (based on their earlier value
> > selections) in order to avoid data entry mistakes.
> >
> > Thanks, Mary-Lou