Thanks, that is another way, but I was hoping for a more user friendly way.
eg like a text box on the sheet that performed the same thing. I know how
to find use 'Edit & Find' and 'Filters', but the users this is aimed at users
with limited experience and knowledge.

Thanks

"Dave Peterson" wrote:

Data|Filter|Autofilter

And then custom filter: Begins with EV
(or equals EV*)

Maybe...

Duncan, UK wrote:

I am creating a list of part numbers of which some will be similar (different
variants of products) and I want to create a user search function eg a search
box that the users could enter the first few letters followed by a wild card
eg EV* and then the products starting with that prefix would be found.
I know you can use the Find function under Edit, but I was hoping for a more
user friendly tool.
Any ideas.
Regards
Duncan

--

Dave Peterson