| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering a Drop Down List
How can I filter the values listed in a drop down list based on values
present in another cell? As in.... [list] Category Description Warehouse Warehouse 1 Warehouse Warehouse 2 Warehouse Warehouse 3 Office Office 1 Office Office 2 [Worksheet] Category Description (Drop Down Filtered based on Category) Warehouse Warehouse 1 Warehouse 2 Warehouse 3 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filtering a Drop Down List
See the instructions for Dependent Lists at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "dch3" wrote: How can I filter the values listed in a drop down list based on values present in another cell? As in.... [list] Category Description Warehouse Warehouse 1 Warehouse Warehouse 2 Warehouse Warehouse 3 Office Office 1 Office Office 2 [Worksheet] Category Description (Drop Down Filtered based on Category) Warehouse Warehouse 1 Warehouse 2 Warehouse 3 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filtering a Drop Down List
What you are referring to is "dependent lists"
See Debra Dalgleish's site for how-to-do. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Mon, 31 Jul 2006 13:29:02 -0700, dch3 wrote: How can I filter the values listed in a drop down list based on values present in another cell? As in.... [list] Category Description Warehouse Warehouse 1 Warehouse Warehouse 2 Warehouse Warehouse 3 Office Office 1 Office Office 2 [Worksheet] Category Description (Drop Down Filtered based on Category) Warehouse Warehouse 1 Warehouse 2 Warehouse 3 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filtering a Drop Down List
Within Access it is a somewhat common practice to alter the values in a drop
down box based on the selection made in another. Behind the scenes, this is as simple as using the value in the first box in the WHERE portion of the SQL statement that populates the second. So then, if I select 'HONDA' in the first box, I only get 'HONDA' cars in the second. "Gord Dibben" wrote: What you are referring to is "dependent lists" See Debra Dalgleish's site for how-to-do. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Mon, 31 Jul 2006 13:29:02 -0700, dch3 wrote: How can I filter the values listed in a drop down list based on values present in another cell? As in.... [list] Category Description Warehouse Warehouse 1 Warehouse Warehouse 2 Warehouse Warehouse 3 Office Office 1 Office Office 2 [Worksheet] Category Description (Drop Down Filtered based on Category) Warehouse Warehouse 1 Warehouse 2 Warehouse 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Use of List box (drop down) | Excel Discussion (Misc queries) | |||
| drop down list of a drop down list | Excel Worksheet Functions | |||
| Conditional Drop Down List | Excel Discussion (Misc queries) | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Linear Mode
