How do I have hierarchial drop down lists in Excel
 

Hi all,
I want to create a heirarchial drop down lists in excel.How do I do it.
For Ex-
Column A has the following drop down elements- Animals,Birds,Continents
Column B should have the following drop down elements depending upon the
selection in column A-
if (A=Animals) B=(Tiger,Lion,Elephant)
if (A= Birds) B=(Crow,Sparrow,Eagle)
if(A=Continents) B = (Australia,Europe,Antartica)
Thanks in advance,
Kunal.

How do I have hierarchial drop down lists in Excel
 

Another good source is Bob Phillips':
http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

How do I have hierarchial drop down lists in Excel
 

Try Debra's page at:
http://www.contextures.com/xlDataVal13.html
Data Validation -- Dependent Dropdowns from a Sorted List
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kunal" wrote:

Hi all,
I want to create a heirarchial drop down lists in excel.How do I do it.
For Ex-
Column A has the following drop down elements- Animals,Birds,Continents
Column B should have the following drop down elements depending upon the
selection in column A-
if (A=Animals) B=(Tiger,Lion,Elephant)
if (A= Birds) B=(Crow,Sparrow,Eagle)
if(A=Continents) B = (Australia,Europe,Antartica)
Thanks in advance,
Kunal.