I have a drop down list in a cell; it currently has 800+ items in the list, so finding one can be time consuming (relatively speaking.) My specialty app programmer has created a way to enter 4-5 characters in a field, press enter, and it pulls up the first 10 matching items. He calls this an "auto fill" feature, for lack of a better name when put on the spot to identify it in a technical way just a moment ago.
I'd like to be able to do something similar in my Excel workbook. For example, in the cell, type in "CNABC" and have the list go to the first or nearest match, so that I can then select that first item or scroll up/down as I normally would.
I'm pretty sure I saw somebody else post on a similar question, but that was over a year ago, and I have no idea what keywords to use to search on it, except "drop down", and well, that could take months looking through all those.
Thanks in advance, as always, to you XL whizzes out there!
XL2003 ON WIN7
I'd like to be able to do something similar in my Excel workbook. For example, in the cell, type in "CNABC" and have the list go to the first or nearest match, so that I can then select that first item or scroll up/down as I normally would.
I'm pretty sure I saw somebody else post on a similar question, but that was over a year ago, and I have no idea what keywords to use to search on it, except "drop down", and well, that could take months looking through all those.
Thanks in advance, as always, to you XL whizzes out there!
XL2003 ON WIN7
Last edited: