Forum Discussion
dmbeach24
Jun 11, 2021Copper Contributor
Auto fill from drop down list as user types
I have a drop down list on one sheet that is populated by a list on another sheet using the Data > Data Validation feature (settings: Allow: List, Ignore blank, In-cell dropdown, Sourse: ='Drop Downs...
HansVogelaar
Jun 11, 2021MVP
Data Validation does not provide AutoComplete - you'd need to use a combo box plus VBA code.
See Data Validation Combo box Click (Excel for Windows only, not on Mac, Android, iOS or on the web)