Dependent Dropdown in Excel

[dileeprajam]

Hi,


I have below requirement, can any one help;
My data is like:
Fruit Country
Apple USA
Apple China
Apple UK
Kiwi Germany
Kiwi UK
Grape USA
Grape Canada


I have to create two dropdowns
Fruit: Apple, Kiwi, Grape
Country: Populate Based on Selected Fruit


I managed to create the Fruit dropdown, but i need help in creating the Country dropdown.


thanks,
-Dileep

 

[FryGirl]

Hi Dileep,

Here is the information which will guide you thru the steps...

http://www.contextures.com/xlDataVal02.html

 

[dileeprajam]

I looked at it; they are creating a sepeate list for fruit, vegetable etc. but here in my case the list will be dynamic and it will be tough to manage.

 

[FryGirl]

Take a look at creating Dynamic Named Ranges

http://blog.contextures.com/archives/2010/04/26/dynamic-excel-named-list-grows-automatically/

 

[dileeprajam]

Thank you all for the responses; i finally achieved it using the links shared by you.

-Regards,
-Dileep