Does anyone know of a way to add autofill functionality to Validation?
I have a list of 700 items on a seperate spreadsheet and am using the
drop-down list function in XL. I would like to be able to enter a few
letters of the item and have the nearest item "fill-in". I've been
searching the web for the last hour and have found a few VB options but
they are for combo boxes and I'm not sure if they would be transferable
to what I'm doing. Thanks.

Jon