drop down list of a drop down list
 

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

drop down list of a drop down list
 

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

drop down list of a drop down list
 

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

drop down list of a drop down list
 

I just did it....use IF function in the list source box.

"Gary" wrote in message
...
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