Hi,
I have created a drop down on an excel worksheet that references a list
on a different worksheet. I do this by using DataValidationList 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

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

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

On 30 Sep 2005 07:01:42 -0700, "Rosa" wrote:

Hi,
I have created a drop down on an excel worksheet that references a list
on a different worksheet. I do this by using DataValidationList 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