Hi,
Is it possible to use data validation on a cell that as you begin to type what you want, a list of all possible matches from a list appears in a drop down list to choose from?
EG
List
Cole
Coope
Cooper
Cummings
As you start to type the 'C', the entire list above would appear. When you then type 'O', Cummings would drop off the list etc etc.
I may be asking for the impossible, I really don't know.
Thanks in advance.
AM
Bookmarks