excel 2003 dropdowns - how to create a child dropdown list based upon what is selected in parent

I'm using named ranges where the ranges are recorded on separate w/sheet named 'DropDowns'.

Column D is used as my parent drop down list. Column E (child column) dropdown list depends upon what was selected in Column D.

Help, please!
kazmdavAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

this is called dependent data validation. A detailed tutorial is here:

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

If you get stuck, post a sample file with your progress.

cheers, teylyn
0
 
krishnakrkcCommented:
Another couple of options here
0
 
kazmdavAuthor Commented:
Working like a charm! Thank you.
0
 
kazmdavAuthor Commented:
Sorry krishnakrkc I didn't notice your response until after I closed the question.
0
 
krishnakrkcCommented:
No issues :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.