Hi,

you need to have a look at dependent data validation. Flit over to www.contextures.com and look at

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

That should get you on the right track without using VBA

cheers