Having problems applying this to my particular situation. But very helpful
just the same. I've gotten myself a couple books now so I'll see if I can't
figure it out. Additional suggestions are still welcome. Thanks again.

-Kent

"Gary''s Student" wrote:

With regard to tiered or dependant dropdowns, see:

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

Let's say we have created the region dropdown in A1 and the state dropdown
in B1. It may not be "clickable". If it is not clickable, then in C1 enter:

=HYPERLINK(B1)

This will produce a nice clickable link.
--
Gary''s Student - gsnu200723