Forum Discussion
Solved
Automatically re-apply filter
Dear Excel funs,
I want to re-apply the filter automatically in the first sheet named "ComingExams". It is attached. When any change happens to any sheet, the filter in the "ComingExams" sheet must be updated. Please note that the data in the "ComingExams" sheet are imported from the other sheets.
VBA solution is accepted.
Thanks
See if this does what you want.
4 Replies
You could reapply the filter in the Worksheet_Activate event of the ComingExams sheet. That way, the filter will be reapplied when you return to this sheet after changing values on one of the other sheets.
- I don't know how. can you help me please ?
I added some vba code copied from the internet but it didn't work. I'm beginner in vba.See if this does what you want.
