I want to reduce the amount of typing i need to do.
ie when i type "dor" in cell a1 on sheet 1 , i need "Dorothy" to appear, as
"Dorothy" is listed on sheet 2 in column 1- autofill of sort . Is thi
possible ?
I have tried data validation but find font and list size of 8 a problem.

Sunil