Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What I want to do is use a drop-list with three(3) options. Based on the
option picked from the first drop-list, the other drop-lists will only display the data relevant to the selected option. This way in the subsequent drop-lists will only display the correct information. For example. Main drop-list has three options: 1. Mild Steel, 2. Stainless Steel, 3. Aluminum Second drop-list will only have the thicknesses for Mild Third will only have thicknesses for Stainless and so on. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're describing Dependent Lists....See Debra Dalgleish's coverage of the
topic for instructions: http://www.contextures.com/xlDataVal02.html Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) " m wrote in message ... What I want to do is use a drop-list with three(3) options. Based on the option picked from the first drop-list, the other drop-lists will only display the data relevant to the selected option. This way in the subsequent drop-lists will only display the correct information. For example. Main drop-list has three options: 1. Mild Steel, 2. Stainless Steel, 3. Aluminum Second drop-list will only have the thicknesses for Mild Third will only have thicknesses for Stainless and so on. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Maybe you could use Data|Validation and use dependent lists.
See Debra Dalgleish's site for some instructions: http://contextures.com/xlDataVal02.html wrote: What I want to do is use a drop-list with three(3) options. Based on the option picked from the first drop-list, the other drop-lists will only display the data relevant to the selected option. This way in the subsequent drop-lists will only display the correct information. For example. Main drop-list has three options: 1. Mild Steel, 2. Stainless Steel, 3. Aluminum Second drop-list will only have the thicknesses for Mild Third will only have thicknesses for Stainless and so on. -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Cascad List With Data/Valid/List.
Items may be add in Lines and Columns wihtout modification. http://cjoint.com/?jjsSmjVC2x Mild Steel Stainless Steel Aluminum 1 4 6 4 6 7 8 8 9 10 14 12 15 Named ranges: choix1:=Offset($F$1,,,,CountA($F$1:$Z$1)) choix2:=$F:$F 1ere liste in B2: Data/Valid/List: =Choix1 2eme liste in C2: Datat/Valid/List: =Offset(choice2,1,Match(B2,Choice1,0)-1,CountA(Offset(choice2,,Match(B2,Choice1,0)-1))-1) JB http://boisgontierjacques.free.fr On 9 sep, 17:54, m wrote: What I want to do is use a drop-list with three(3) options. Based on the option picked from the first drop-list, the other drop-lists will only display the data relevant to the selected option. This way in the subsequent drop-lists will only display the correct information. For example. Main drop-list has three options: 1. Mild Steel, 2. Stainless Steel, 3. Aluminum Second drop-list will only have the thicknesses for Mild Third will only have thicknesses for Stainless and so on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I select multiple options in an Excel 2003 drop down list | Excel Discussion (Misc queries) | |||
Assigning values to drop-down list options | Excel Discussion (Misc queries) | |||
How do I delete the drop down list of header / footer options in e | Excel Discussion (Misc queries) | |||
validation list with drop down list of options?? | Excel Worksheet Functions | |||
How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) |