AutoComplete
 

I have read various Q & A's regarding this subject and still having a hard
time getting the results I need.

On Sheet B, I have a list on 2500 names starting on A2.

On Sheet A F2, I would like to start to type a name and a list to come up
that I can choose an entry or the more of the name I type the list gets
smaller.

Example: I type wh a list comes up in drop down format with
White, Blue
White, Yellow
Whyte, Green

However if I continue to type why the first two enteries are removed.

Is this possible in Excel? If so HELP ..........

Much thanks,

Cathy