You can create dependent data validation dropdowns, as described he

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


The Joe wrote:
Im currently working on a spreadsheet that uses several in-cell pulldowns. My
workbook contains 10 different tabs. Each tab has the same fields but the
drop downs are different (tab specific). To do this I have just created
different lists on my data tab and everything works fine. However, what I
would like to do is be able to merge all my tabs into one and make a master
pull down field in my first column. In doing so, I want to be able to have
all my fields that use pulldowns be able to recognize what list to use based
on the entry in the first column. Ive tried several different ways to do
this I can not figure it out. So, if any of you know how to do this and would
not mind trying to explain I would be very appreciative. Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html