On Apr 1, 8:00*pm, "Roger Govier" <roger@technology4unospamdotcodotuk
wrote:
Hi Tom

Take a look at the code in the FastFilter utility that I wrote, which is
available athttp://www.contextures.com/Fastfilter.zip
orhttp://excelusergroup.org/files/folders/allversionwb/entry1194.aspx

Maybe that will help you.
--
Regards
Roger Govier

"Tom" wrote in message

...



Would like to create code which will allow someone to type in a
specific number then would sort the spreedsheet to show just rows
that
have that specific number. I know you can do this with just using the
autofilter drop down, but I want to make it more user friendly buy
just having them type it in a cell then click a button.

Any help would be appreciated.
Tom- Hide quoted text -

- Show quoted text -

Roger,
This works great, just one minor issue. The wildcard feature will not
work on 95* numbers. I checked the format and is correct, can't figure
this one out.