| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Categorize drop down list
Hi,
I'm trying to limit the length of a drop down list. Products: A,B,C,X,Y,Z Category: High Value, Low Value If i choose "High Value" in the 1st column, can the drop down list at 2nd column only shows A, B, C instead of showing all products? Thanks |
|
#2
|
|||
|
|||
|
Dependent validation list or comboboxes?
for the first see http://www.contextures.com/xlDataVal02.html or http://www.ozgrid.com/News/excel-dependent-lists.htm DM Unseen |
|
#3
|
|||
|
|||
|
Got it. Thanks! A great website to refer in future too!
"DM Unseen" wrote: Dependent validation list or comboboxes? for the first see http://www.contextures.com/xlDataVal02.html or http://www.ozgrid.com/News/excel-dependent-lists.htm DM Unseen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| Drop List Referencing | Excel Worksheet Functions | |||
Linear Mode
