Drop Down - Jump to selection

[Rosa]

Hi,
I have created a drop down on an excel worksheet that references a list
on a different worksheet. I do this by using Data>Validation>List and
entering the name of the list that I have created on the other
worksheet. So far so good.

The problem is that I cannot directly jump to a part of the list, e.g.
List
a 10
a 12
b 11
b 13
b 15
c 3

I would like to be able to click on "b" so that my selection would be
shorter and I wouldn't need to worry about the other values. But this
doesn't work. I have tried using a combo box from the Forms toolbar,
but I have the same problem.

Any help is greatly appreciated.
Thanks
Rosa

 

[Rosa]

Hello again,
I've just seen that this question has already been posted on this group
and that the answer is that it won't work unsless using some code.
See: http://www.contextures.com/xlDataVal11.html
Thanks anyway
Rosa

 

[Gord Dibben]

Rosa

Perhaps a dependent list would do the trick.

Click on b and see options for just b's

http://www.contextures.com/xlDataVal02.html


Gord Dibben Excel MVP