If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA For Advanced Filter Auto-Update on Multiple Sheets

Thread starter simon73
Start date Nov 2, 2016
Tags

advanced filte advanced filtering advanced filters vba

simon73

New Member

Nov 2, 2016

Hi,

I have a workbook with over 50 Sheets.

I have set up advanced filters on in excess of 30 sheets.

I would like to find a way to use VBA code to update the existing advanced filters that i have set when there is a chance to the woorkbook.

I have managed to enter some code but it is based on worksheet change and annoyingly chganges the active sheet on execution and only updates one of the active filters.

Hopefully someone on this forum can help..

I am left wondering why Excel havent built this feature in?

Any help would be most gratefully appreciated

Thanks for taking the time to read