Data validation dependencies
 

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

Data validation dependencies
 

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" wrote in message
...
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

Data validation dependencies
 

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

Data validation dependencies
 

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" wrote in message
...
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

Data validation dependencies
 

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