Forum Discussion
drop down list and autofill
I have an excel workbook with a drop down list in column F that contains 25 or so of my most common location names. I would like to be able to continue to use the drop down but also be able to autof...
Thanks for your response. Unfortunately, I need to keep my existing drop down box for my most common 25 locations, but I would like to autofill also. The match first letter entry would be a big help. The reason I need the autofill is so other formulas in my workbook will function based on an exact match to the location name. There is too much margin for error when several people are typing in their version of a location name.
Any other options?
Other than what I've suggested, is Excel VBA Macro. Meanwhile you may check this little back I've solved Autocomplete Excel Drop down list . Or you may Check this also, is bit tedious!
Every where you find that the Combo box is the ultimate choice.