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.