DATA VALIDATION

[Guest]

DATA VALIDATION - LIST - SOURCE; the entries on my "source" name is so long
that I would like it to automatically go to the first selection when I type
the first letter of what I'm looking for. Is this at all possible?

 

[Guest]

No. and Yes. Regular data validation does not provide
auto-select/auto-complete. But one solution to the issue has been provided
by Debra Dalgliesh at contextures.com:
http://www.contextures.com/xlDataVal10.html

 

[Guest]

Awesome, you made me looked like I'm an expert. Thanks much.

 

[L. Howard Kittle]

If using the data validation drop down you can do this. Sort your list to
have all the entries that begin with a at the top and the b's next all the
way to z.

At the beginning of each letter change in the list enter a single a at the
beginning of the a's, same with a b at the beginning of the b's etc. on to
z.

To go to the beginning of the t's for example, just type t in the drop down
cell and DON'T hit enter. Click on the drop down arrow and the t list will
appear. (You can hit enter after typing the letter but then you have to
reselect the drop down cell, just saves a step)

HTH
Regards,
Howard

 

[Guest]

You can thank me for pointing you to Debra's site, she's actually the one
that made you look brilliant this time. Glad I could help.