Lead Letter to be come when typing (Searchable Drop Down List)

Question

Hi Every One&nbsp;I have table A and Table B with me.&nbsp;Table B is master list of items with prices.&nbsp;&nbsp;In Table A I need to put input item name, for that it will be difficult to enter full name every time from Table B.&nbsp;So that I need to use a data validation trick to enter the data.&nbsp;What I need is, whenever we enter first letter, in searchable area, suggested list of items from Table should appear. The Data entry man can choose the item to proceed.&nbsp;Is there any VBA of formula for this????&nbsp;&nbsp;&nbsp;

patrick2788 · Answer

Sameer_Kuppanath_Sultan&nbsp;Are you looking for something like this?&nbsp; This feature is currently available to Office insiders Beta channel.&nbsp;

sameer_kuppanath_sultan · Answer

I AM USING MICROSOFT 365.

sameer_kuppanath_sultan · Answer

Also, I want to allocate this job to my subordinate, they dont have any latest version of MS Office.Because their job is limited to Data Entry Only.

cangkir · Answer

You can try using a free Excel add-in "Search deList". You can find it here:https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/It gives you a unique, sorted &amp; non-empty list, and you can search by multiple keywords.

sameer_kuppanath_sultan · Answer

Cangkir Thank You.But I need the same thing in Cell while start typing letters in the same cell, not with User Forms.That is, Instead of Userform, I need to use it in Cells itself.

Forum Discussion

Lead Letter to be come when typing (Searchable Drop Down List)

5 Replies

Resources