Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select from a list - 2003 Xls
I am using Xls 2003
i want to make a list of item - let call it list A then i want to select one of the items in list A and another list (say list B) must give me the details of the item selected in list A. let use an example List A = 1) car 2) boat 3) bicycle when i select 1) car - List B show me 1) 4 doors 2) 4 wheels 3) stearing wheel when i select 2) boat - List B show me 1) sail 2) rudder 3) sailers when i select 3) bicycle - List B show me 1) 2 wheels 2) peddals 3) saddle can i do this in excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select from a list - 2003 Xls
Debra Dalgleish explains these dependent lists:
http://contextures.com/xlDataVal02.html (Using Data|Validation) Janna wrote: I am using Xls 2003 i want to make a list of item - let call it list A then i want to select one of the items in list A and another list (say list B) must give me the details of the item selected in list A. let use an example List A = 1) car 2) boat 3) bicycle when i select 1) car - List B show me 1) 4 doors 2) 4 wheels 3) stearing wheel when i select 2) boat - List B show me 1) sail 2) rudder 3) sailers when i select 3) bicycle - List B show me 1) 2 wheels 2) peddals 3) saddle can i do this in excel? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select from a list - 2003 Xls
Please refer the below link by Debra Dalgleish
on the subject "Excel -- Data Validation -- Dependent Dropdowns from a Sorted List " http://www.contextures.com/xlDataVal13.html "Excel Data Validation -- Create Dependent Lists" http://www.contextures.com/xlDataVal02.html -- Jacob "Janna" wrote: I am using Xls 2003 i want to make a list of item - let call it list A then i want to select one of the items in list A and another list (say list B) must give me the details of the item selected in list A. let use an example List A = 1) car 2) boat 3) bicycle when i select 1) car - List B show me 1) 4 doors 2) 4 wheels 3) stearing wheel when i select 2) boat - List B show me 1) sail 2) rudder 3) sailers when i select 3) bicycle - List B show me 1) 2 wheels 2) peddals 3) saddle can i do this in excel? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select from a list - 2003 Xls
Thank you for the information - 100% answered
"Dave Peterson" wrote: Debra Dalgleish explains these dependent lists: http://contextures.com/xlDataVal02.html (Using Data|Validation) Janna wrote: I am using Xls 2003 i want to make a list of item - let call it list A then i want to select one of the items in list A and another list (say list B) must give me the details of the item selected in list A. let use an example List A = 1) car 2) boat 3) bicycle when i select 1) car - List B show me 1) 4 doors 2) 4 wheels 3) stearing wheel when i select 2) boat - List B show me 1) sail 2) rudder 3) sailers when i select 3) bicycle - List B show me 1) 2 wheels 2) peddals 3) saddle can i do this in excel? -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
Excel 2003 - function to select a value | Excel Worksheet Functions | |||
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
How can I select multiple options in an Excel 2003 drop down list | Excel Discussion (Misc queries) | |||
how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions |