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

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

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