Thread: Drop Down List
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Drop Down List

hi
yes it is. it's call cascading combos or dependent combos.
i am assuming that you are using data validation.
see this site for more details on how to set it up.
http://www.contextures.com/xlDataVal02.html

regards
FSt1

"cp402" wrote:

I want to organize different types of products using drop down lists:

1) drop down list of manufacturers (easy)

2) depending on the manufacturer chosen I want their SPECIFIC PRODUCTS ONLY
to be seen in the second drop down list

3) once I have chosen the product info in other fields appears such as unit
price, etc

I have been told I cant do this in Excel... is this true?