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