Hello,

have a look at dependent data validation here: http://www.contextures.com/xlDataVal02.html

cheers,