How do I write a Macro To Perform same Advanced Filter on Different Worksheets in Workbook

[PWinkz]

Hi guys,

i have advanced filter activated on the sheet August which i have recorded a macro with and assigned to a button.
Now, my problem is, i want the same macro to do the same filter for the other sheets "September, October..." instead of having to record another macro for each sheet.

And I'll like the filter to update automatically as more data is added to the table.

Thanks in advance...and i have attached a sample sheet...macro for workbook.xlsm

[arlu1201]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.