Drop down list question

T

Tracey

I have a template with several drop down lists for the user to selec
from. I would like it to function in a way that the user only needs t
enter the first couple of numbers and the list will scroll to that par
of the list. Is this possible
 
J

Jason Morin

Move your source cells for the list to directly above the
validation cell, and then hide those cells. For example,
if your source range is J1:J5, and the validation is in
A10, move the range to A5:A9.

HTH
Jason
Atlanta, GA
 
T

Tracey

Thanks, that works great, for the lists that contain text. It doesn't
work for lists of numbers, for example i have one drop down list in
which the user has to pick a department number, and it doesn't work.
Is there a tip for making this work with numbers?
thanks in advance.
 
J

Julian Mattay

Thanks, that works great, for the lists that contain text. It doesn't
work for lists of numbers, for example i have one drop down list in
which the user has to pick a department number, and it doesn't work.
Is there a tip for making this work with numbers?
thanks in advance.
Click to expand...

Possibly change the numbers to text? Haven't tried it though.

Cheers,
Julian

--
Julian Mattay, email: julian x mattay z csiro x au
(where x -> dot, z -> at)
Local IT Bloke
CSIRO, Forestry and Forest Products Ph: +61 8 8721 8118
Mt Gambier, South Australia, Australia Fax: +61 8 8723 9058
 
Top