Data validation dependencies

[MLK]

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

 

[Bob Phillips]

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)

 

[Toppers]

See:

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

 

[MLK]

Thanks, that's it!

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]

This is what I'm looking for. Thanks.

See:

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