Hi there,



I am populating a drop down list by using data validation as shown in the screenshot attached (attached excel book too).

The functionality I would like is:
Rather than having to scroll down a (potentially) very long list, I want to be able to start typing a customer name and the drop down "finds it". The functionality is very similar to that of Windows when you are in a particular directory, as you type windows explorer starts taking you "down to " the matching file name. What I need looks a lot like this http://www.excelautocomplete.com/, but I don't want to have to install an addin... I'm a little scared of that. Also, I'd have to install it for all my users.


In short:
I don't want to have to scroll a whole lot to select my customer.
My customer list is ever growing as per the entries in Table1.
Could anyone please suggest an elegant solution to "get me to my customer" ?




Thanks in advance,
Michelle

Attached Images

Screenshot1.jpg (82.9 KB, 20 views)

Attached Files

Book1.xlsx (9.2 KB, 15 views)

Perhaps http://www.ozgrid.com/Excel/autocomplete-validation.htm

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank-you very much Pecoflyer, but it is however not an option to put per-populated data in the rows above (even if I hide them). Thanks though for your reply.

If you create a named range =Table1[Company]
and use that named range for your data validation
then this will do what you're wanting.