#1
|
|||
|
|||
Find drop down list entry with keystrokes
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 |
#2
|
||||
|
||||
__________________
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 |
#3
|
|||
|
|||
Quote:
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. |
Tags |
autocomplete, data validation |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down box list based on response to another drop down box | Phideaux | Excel | 16 | 04-13-2018 03:07 AM |
Win 8.1 won't allow entry from drop down list in Outlook | nphutchnson | Outlook | 0 | 10-18-2014 10:46 AM |
Trying to update a table cell with a value based on a drop down box entry | mkasem | Word VBA | 2 | 09-29-2013 08:36 PM |
Drop-down Populated with text entry | ReviTULize | Word VBA | 14 | 02-21-2013 07:06 PM |
autocorrect: cannot find corresponding entry that produces particular behavior | beej | Outlook | 1 | 11-02-2012 12:19 PM |