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