Okay...what Duncan, UK is trying to do is essentially what I am trying to do,
except that I want to make it EVEN EASIER for the user, so that he/she can
enter the text into a Text Box Form and press Enter, and the data will be
AutoFiltered by the text string that they have just entered.

How can I do that?

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