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.

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.