Hello 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,...I have attached the excel sample sheet..macro for workbook.xlsm
Bookmarks