Paul has attended:
Excel Advanced course
Data Validation
When I have a drop down list on a data validation, how can I get excel to autofill the rest of the list? Eg as I type Joh.. it brings my options to joh
RE: Data Validation
Hi Paul,
Thank you for your question and welcome to the forum.
The only way I can see of doing it is using a combo box and set the properties for autocomplete.
Please find the link below that hopefully will help you.
http://www.contextures.com/xlDataVal11.html
Have a good weekend.
Regards
Simon