Hey guys!
I have a list of over 600 words that I would like to populate into a cell when you start typing the first letter.
They are in alphabetical order, so if you type the letter "M", I would like the list to show the words starting with "M".
Currently I tried the List Option under Data Validation, but it does not appear to work that way. It will only show the entire list starting at "A".
If you start typing a letter, such as "M" and then proceed to hit the drop-down arrow, you get an error, because "M" is not a word in the list. I was hoping it would show the words starting with "M".
If you click the drop-down arrow first, with no words in the cell, it will start at the beginning, which I would expect. But if I try to type a letter, such as "M", nothing happens; it does not move to the words beginning with "M" as I was hoping for.
So, is there an easy way to accomplish this task?
Mike
Bookmarks