drop down list

  • Thread starter drop down list with related values
  • Start date
D

drop down list with related values

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
drop down list 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Limit drop down items based on another cell 3
Formatted cell column in drop down list 1

Top