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.