conditional drop down

[sunil.kini]

In the attached excel file there are list of names and list of cities. If I select city as "DELHI" for "A", I should not get "DELHI" in subsequent drop downs. Means next drop downs should show only remaining cities. Please help me on this.<!-- google_ad_section_end -->

 

[Smitty]

Sorry, it's still not clear to me what you're trying to accomplish.

 

[sunil.kini]

In the downloaded zip file example given for 6 cells. I want the same for 500 cells

 

[sunil.kini]

I have a list of 500 employees and 500 cities. I want to link one to one. But in the given excel file it allows only 6 employees and 6 cities. I want only the modification in the formula to accomodate 500 cells.
Probably I am clear to you.

 

[Smitty]

A Data Validation list is limited to the number of entries you can see when you click on it, but it can easily handle 500, you just need to scroll down through the list.

If you want something that will allow you to auto-scroll with the keyboard (i.e. hit L - go to Lahore), then you need to use an ActiveX ComboBox. If you want to display all 500 entries, I might consider using a ListBox, but you still won't be able to display all 500 at once unless your screen zoom is set incredibly low.

 

[sunil.kini]

But my drop down shows only first 6 drop downs. even though I have 500 list. I can e ma il you the sheet if you want.

 

[Smitty]

A Data-Validation list will only display the first 8 entries in a list. The rest are there, but you need to scroll down to them. If you need more locations displayed see: http://www.contextures.com/xlDataVal10.html

 

[sunil.kini]

But I am not getting only 6 entries. Sent uploaded file link via PM.

 

[sunil.kini]

Please Help me out

 

[sunil.kini]

Uploaded file link http://www.megaupload.com/?d=JC7OE57B. Please help me. Thank You

 

[Smitty]

Sorry, I'm like a lot of others and am blocked from file/image sharing sites.