| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create a drop-down list that will reference other drop-down
-- Thanks for your help in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I create a drop-down list that will reference other drop-down
You can create dependent data validation lists. There are instructions
he http://www.contextures.com/xlDataVal02.html fdebelo wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I create a drop-down list that will reference other drop-down
I have a drop down list in A3 with 2 items in the list. If i select the item
1 from A3 list, I would like to open the drop down list in A4, and see the list associated with item 1 in A3. If I select item 2 in A3, the list in A4 would be a different list, one that is associated with A3. is this possible without utilizing access? -- Thanks for your help in advance. "fdebelo" wrote: -- Thanks for your help in advance. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I create a drop-down list that will reference other drop-down
In a simple example as you give, all you need is something like this formula
in your second DV, type of list =if(F1=1,m1:M4,N1:N4) better still use named ranges. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "fdebelo" wrote in message ... I have a drop down list in A3 with 2 items in the list. If i select the item 1 from A3 list, I would like to open the drop down list in A4, and see the list associated with item 1 in A3. If I select item 2 in A3, the list in A4 would be a different list, one that is associated with A3. is this possible without utilizing access? -- Thanks for your help in advance. "fdebelo" wrote: -- Thanks for your help in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| re-ordering the list on a filter drop down | Excel Discussion (Misc queries) | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
| How do I get LIST on the DATA menu bar-I need Create List | New Users to Excel | |||
| How do I create a drop down list in Excel 2003 | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Linear Mode
