Thread: Dropdown lists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Grandt Grandt is offline
external usenet poster
 
Posts: 1
Default Dropdown lists

I have 4 dropdown lists in Excel.

How do I limit the options in dd-list 2,3 and 4

In column A, I choose between e.g. Nokia and Sone-Ericsson- I choose Nokia
In column B, I only want Nokias models e.g. E65, N95 etc. etc.
Etc.
Etc.

Can anyone tell me how to limit the choices ??

Thanks in advance