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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"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