Macro to run filter on existing table

[Guest]

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.

 

[Tom Ogilvy]

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.