dropdown
 

hi,

i have 3 dropdown boxes in my sheet. one is [state] and the other is
[facility]. so lets just say i want to limit the [facility] one to only
those which are in the selected [state]. what is the best way to do this?
are there any examples out there?

thanks in advance,
geebee