Copy Address Bar Functionality
 

Hi All,

I have a work book with around 100 different Names listed, I would like
to be able to activate a cell so that when I start typing the first
part of the stored name my option are displayed similar to how the
address bar works in web browsers.

When I type the "M" in Mark my list is reduced to Marie, Mark, Mary

Hope this makes sense?

Thanks

Mark

Ann
Barry
Chris
Fred
Marie
Mark
Mary
Paul
Peter
Zoe