Macro to run filter on existing table
 

I have a table consisting of a set of records in Excel and i need to show a
subset of these records, based on user input filtering criteria applied on
one of the columns in the table. Would like to know a simple macro (code)
that can achieve this. Any other suggestion to achieve this would also be
helpful.

Thanks.

Macro to run filter on existing table
 

Turn on the macro recorder and apply and autofilter

Data=Filter=Autofilter
then select a criteria.

Turn off the macro recorder and modify the code to allow you to apply user
inputted criteria.

--
Regards,
Tom Ogilvy

"PMishra" wrote in message
...
I have a table consisting of a set of records in Excel and i need to show
a
subset of these records, based on user input filtering criteria applied on
one of the columns in the table. Would like to know a simple macro (code)
that can achieve this. Any other suggestion to achieve this would also be
helpful.

Thanks.