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 dowm, 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

see response to your question in excel.programming

--
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 dowm, 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