Search with wild (*) character

Hello Excel Gurus,

I have the code below that needs minor revision. Right now it only display the exact match when found.

The revision I want is if I type “ENGLISH” on cell “A2”, it will display all the Description that contain the word “ENGLISH” whether it is “ENGLISH/SPANISH” or “ENGLISH VERSION”, “SPANISH/ENGLISH”, “English/Italian”, “Spanish-Eng”, etc. as long as the cell contain the word “ENGLISH" whether in the beginning, middle or last. (Lower or upper case). Maybe a search with wild (*) character.

Also, if 2 or more exact match is found, display only one. (remove duplicate)

I am newbie on writing a Macro.

Any help would be appreciated.

Thank you.

HERE IS THE CODE

Please Login or Register  to view this content.