Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a dependent list, to a current list?
I am trying to create a dependent responing list to another drop down list in
excel. I.e. Drop down list 1: 1 2 3 Drop Down list 2: A B C If I selected 2 from the fist list I would want list two to automatically register B. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a dependent list, to a current list?
Try Deb's solution he
http://www.contextures.com/xlDataVal02.html These are called "cascading" or "dependent" drop-downs. :) ************ Hope it helps! Anne Troy www.OfficeArticles.com "elevenphil" wrote in message ... I am trying to create a dependent responing list to another drop down list in excel. I.e. Drop down list 1: 1 2 3 Drop Down list 2: A B C If I selected 2 from the fist list I would want list two to automatically register B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create A List From A List | Excel Worksheet Functions | |||
Create a list range | Excel Worksheet Functions | |||
How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) |