Mike,
Take a look he

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

HTH

"Mike Dantuono" wrote:

How do I create a cell with a drop-down that is conditional on another
drop-down cell. For example, I have a cell that includes all 50 states. I
would like the subsequent cell to be a drop-down with all of the counties of
the state that the end user selects in the previous cell. Any assistance is
appreciated.

-Mike