How do I have hierarchial drop down lists in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kunal - 20 Mar 2006 15:59 GMT

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.

Reply to this Message

Max - 20 Mar 2006 16:08 GMT

Try Debra's page at:
http://www.contextures.com/xlDataVal13.html
Data Validation -- Dependent Dropdowns from a Sorted List

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi all,
> I want to create a heirarchial drop down lists in excel.How do I do it.
[quoted text clipped - 7 lines]
> Thanks in advance,
> Kunal.

Reply to this Message