Auto fill from drop down list as user types

%3CLINGO-SUB%20id%3D%22lingo-sub-2440931%22%20slang%3D%22en-US%22%3EAuto%20fill%20from%20drop%20down%20list%20as%20user%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440931%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20drop%20down%20list%20on%20one%20sheet%20that%20is%20populated%20by%20a%20list%20on%20another%20sheet%20using%20the%20Data%20%26gt%3B%20Data%20Validation%20feature%20(settings%3A%20Allow%3A%20List%2C%20Ignore%20blank%2C%20In-cell%20dropdown%2C%20Sourse%3A%26nbsp%3B%3D'Drop%20Downs%20List'!%24A%242%3A%24A%241399).%20The%20problem%20is%20that%20the%20user%20has%20to%20scroll%20down%20through%201397%20rows%20of%20department%20options.%20How%20do%20I%20add%20an%20auto%20fill%20feature%20that%20will%20start%20to%20complete%20the%20cell%20or%20at%20least%20narrow%20down%20the%20list%20as%20the%20user%20types%20in%20the%20text.%20Do%20I%20have%20to%20use%20VB%20script%20or%20is%20there%20an%20easier%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2440931%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2440949%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20from%20drop%20down%20list%20as%20user%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1069575%22%20target%3D%22_blank%22%3E%40dmbeach24%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EData%20Validation%20does%20not%20provide%20AutComplete%20-%20you'd%20need%20to%20use%20a%20combo%20box%20plus%20VBA%20code.%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2FxlDataVal14.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EData%20Validation%20Combo%20box%20Click%3C%2FA%3E%20(Excel%20for%20Windows%20only%2C%20not%20on%20Mac%2C%20Android%2C%20iOS%20or%20on%20the%20web)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 List'!$A$2:$A$1399). The problem is that the user has to scroll down through 1397 rows of department options. How do I add an auto fill feature that will start to complete the cell or at least narrow down the list as the user types in the text. Do I have to use VB script or is there an easier way to do this?

1 Reply

@dmbeach24 

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)