drop down list

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

Check this out:
http://www.contextures.com/xldataval02.html

--
Best Regards,

Luke M
"drop down list with related values" drop down list with related
wrote in message
...
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