drop down list
in [Functions]
|
Prev: in MS EXCLE how we can protect only one cell?
Next: How do I export a Pivot Table in Excel into Word?
From: drop down list with related values drop down list with related on 24 May 2010 08:47 hi all, i am currently trying to create a worksheet which would have a drop down list containing descriptions from the description column (i.e. 1,2,3,4...10). description C2 C3 C4 1 a b c 2 d e f 3 g h i 4 j k l 5 m n o 6 p q r 7 s t u 9 v w x 10 y z 0 when i used validation for this excercise, it provides the drop down list which is good. The issue what i am facing is that when i select the value (eg.2) i want it to filter out all other values in that row and just show the values related to 'Description 2' which should be displayed in their own individual cells. i know the approach what i have used is not correct and also, i want to avoid the autofilter option. Please help me. seb
From: Luke M on 24 May 2010 08:50
Check this out: http://www.contextures.com/xldataval02.html -- Best Regards, Luke M "drop down list with related values" <drop down list with related values(a)discussions.microsoft.com> wrote in message news:6EA57D65-349B-445E-8CFF-DE45B7C7E169(a)microsoft.com... > hi all, > i am currently trying to create a worksheet which would have a drop down > list containing descriptions from the description column (i.e. > 1,2,3,4...10). > description C2 C3 C4 > 1 a b c > 2 d e f > 3 g h i > 4 j k l > 5 m n o > 6 p q r > 7 s t u > 9 v w x > 10 y z 0 > when i used validation for this excercise, it provides the drop down list > which is good. The issue what i am facing is that when i select the value > (eg.2) i want it to filter out all other values in that row and just show > the > values related to 'Description 2' which should be displayed in their own > individual cells. > i know the approach what i have used is not correct and also, i want to > avoid the autofilter option. > Please help me. > seb > |