Sounds like Debra Dalgleish's instructions on creating Dependent Lists using
Data Validation might work.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 11:36:00 -0700, Grandt
wrote:

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