Nov 30 2020 02:35 PM
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 autofill the cells if I type a location name similar to a name within a data range from another sheet. Is this possible?
I apologize if I am putting this question in the wrong place.
TIA
Nov 30 2020 09:16 PM
You need to use Combo Box.instead of a Drop Down.
How it works:
Now hit Combo Box, list of locations will appear, type the first letter of location.
Dec 01 2020 09:52 AM
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?
Dec 02 2020 05:05 AM
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.