MS Excel Flash Fill and Filtering Option with VBA .

[KAM_Mumin]

Hi Everyone!

I want to fill up cell manually by typing keywords but the problem is which text I want to type that is so big word some time and there are so many types of items there which I need to type on the cell for data entry of stock. Is there any solution? for when I type some words then the related word items list will show on the below like filter list or show flash fill related word,,, 

I tried to find some options for making this but if I made the dropdown list by the cells reference, the list will very large and difficult to found by clicking from the dropdown list,,,

Please any of you have a solution for this then please reply.. I attach below a screen short for understanding,,

[#2 · Accepted solution]

@KAM_Mumin 

Attached is an older example (Excel 97) with VBA.

You only need to type letters in the drop down box and it will show you all existing ones with those letters for you to select.

I'm not sure if this is exactly what you're looking for, but it might help.

Haven't tried it in Excel 365.

 Hope I was able to help you with this file.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@KAM_Mumin 

Try a free Excel add-in called “Search deList”.
It works like this:
In any cell that has data validation (with List type) pressing ALT+RIGHT will open a searchable combobox.
Type some keywords to search, separated by a space, e.g "ma la"
The list will be narrowed down as you type.
Hit ENTER to sent the value to active cell.
You don't need VBA, so you can save your workbook as .xlsx.

It works on large data (tested on 100K rows)

You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searc...

[#4]

@NikolinoDE  can you please help me how can I make this list like you on my list,, I attach below a screen short for understanding,,