I think you can use IF THEN function instead of only values where u make the
second list..provided your list is not too long......if possible...reply
with what u want in the first list and in the second list what is based on
what.
"Hapitaron10"
wrote in message
...
I want to create a drop down list that will be based on the pick the you
choose from the previous drop down list
thanks
--
Hapitaron10
------------------------------------------------------------------------
Hapitaron10's Profile:
http://www.excelforum.com/member.php...o&userid=34835
View this thread: http://www.excelforum.com/showthread...hreadid=547981