Auto-Populate name while typing first letter

HI

I need help ( sorry for my English )
If I have a list of name, let say 200 names in 1 column in 1 worksheet

Is there anyway I can add a macros in order to be able to start typing their name and after 1-2 letters , the system will know what name I want from the list ? A bit like Siri does in Iphone....

So for example, I have a list with 200 names... and on the first page , I want to put their name beside a list of task... I will like to type pa,,,, so everything with Pa..like Patrick will automatically pop-up...

Is this possible ?

.
This macro (paste in Sheet Level module for Sheet 1) will search all words, all columns/rows on Sheet 1 as you type :

Please Login or Register  to view this content.