Drop down list question

  • Thread starter Thread starter Tracey
  • Start date Start date
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
 
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
 
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.
 
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
 
Back
Top