Filtering Data with Macro
There is an Excel file that teaches how to perform the Filtering Data with Macro operation.
Excel-Based Filtering Data with Macro
This workbook applies VBA-driven auto-filtering on a 12-row dataset with Text and Number columns, with a 5-row reference list on a second sheet.
Hope it is useful.