| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Lists
I need to create a drop down list, that changes selections, based on the
value of a different cell. For instance, if the value in the key cell is Apples, then the drop down list will have different kinds of apples for the selections. If the value in the key cell is Peaches, then the same drop down list will now show different kinds of peaches for the selections. How is this done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down Lists
See if this helps:
http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "David Robinson" wrote in message ... I need to create a drop down list, that changes selections, based on the value of a different cell. For instance, if the value in the key cell is Apples, then the drop down list will have different kinds of apples for the selections. If the value in the key cell is Peaches, then the same drop down list will now show different kinds of peaches for the selections. How is this done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down Lists
FWIW, there's a pretty great explanation of cascading dropdown
validation lists in Professional Excel Development, towards the beginning of the book. Much simpler than the other methods I've seen. --JP On Apr 15, 10:09*pm, "T. Valko" wrote: See if this helps: http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "David Robinson" wrote in message |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP Drop Down Lists | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| drop down Lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Linear Mode
