a little help?

[BBB]

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.

 

[Pete_UK]

Debra Dalgleish has some notes on dependent data validation here:

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

Hope this helps.

Pete

 

[BBB]

thats perfect. thanks pete

Debra Dalgleish has some notes on dependent data validation here:

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

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

Pete

thats perfect. thanks pete