more advanced drop down functionality 1

[bnsSteve]

Hello,

I'm wondering if I could get help in creating a drop down in one cell that when you select an item in the that drop down, it will change what appears in the next drop down.

Ex: Cell A1 has drop down with a list of key words. If I select the first key word in that list. I will get a list in the next cell say A2 that corresponds to the key word I selected in A1.

I'm assuming I cannot do this by simply using Data Validation? Also if possible, having an auto complete function would be great!

I hope I explained it clearly. Thanks!

 

[bnsSteve]

Sorry I guess it would help if I note that I'm trying to do this in Excel 2007.

 

[bnsSteve]

Sorry no need to follow up on this, did some research and found a link that ended up being helpful. Not a fancy solution but did what I needed.

Here's the link if anyone needs a reference for this.

http://excel.tips.net/Pages/T002972_Creating_Dependent_DropLists.html

Thanks.

 

[SkipVought]

Hi,

I regularly use MS Query to generate sucessive lists based on a user list selection. Pretty simple, once you work out the process. It can even be done without VBA code, using Data > Validation List & PARAMETER pointing to the selected DV value.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bnsSteve]

Great, thanks for the tip Skip.