hi,

what i am trying to do is have a validation or list provide options from
another valiadation. this is so that i can select a category "A" in the
first column, then under that category there are a list of options, "AB"
"AB1" "AC" "AD" etc. then from the sub category the third column returns a
reference.

is there a way to make a list similar to the way validation works for the
second category? so the you can only select a sub category that relates to
the first category?

thanks.

Debra Dalgleish has some notes on dependent data validation he

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

Hope this helps.

Pete

On Jul 10, 1:58*am, BBB wrote:
hi,

what i am trying to do is have a validation or list provide options from
another valiadation. *this is so that i can select *a category "A" in the
first column, then under that category there are a list of options, "AB"
"AB1" "AC" "AD" etc. then from the sub category the third column returns a
reference.

is there a way to make a list similar to the way validation works for the
second category? so the you can only select a sub category that relates to
the first category?

thanks.

thats perfect. thanks pete

"Pete_UK" wrote:

Debra Dalgleish has some notes on dependent data validation he

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

Hope this helps.

Pete

On Jul 10, 1:58 am, BBB wrote:
hi,

what i am trying to do is have a validation or list provide options from
another valiadation. this is so that i can select a category "A" in the
first column, then under that category there are a list of options, "AB"
"AB1" "AC" "AD" etc. then from the sub category the third column returns a
reference.

is there a way to make a list similar to the way validation works for the
second category? so the you can only select a sub category that relates to
the first category?

thanks.

You're welcome.

Pete

"BBB" wrote in message
...
thats perfect. thanks pete

"Pete_UK" wrote:

Debra Dalgleish has some notes on dependent data validation he

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

Hope this helps.

Pete

On Jul 10, 1:58 am, BBB wrote:
hi,

what i am trying to do is have a validation or list provide options
from
another valiadation. this is so that i can select a category "A" in
the
first column, then under that category there are a list of options,
"AB"
"AB1" "AC" "AD" etc. then from the sub category the third column
returns a
reference.

is there a way to make a list similar to the way validation works for
the
second category? so the you can only select a sub category that relates
to
the first category?

thanks.