Forum Discussion
chamseddine_hamdeni
Oct 17, 2021Copper Contributor
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 mu...
- Oct 17, 2021
See if this does what you want.
HansVogelaar
Oct 17, 2021MVP
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.
chamseddine_hamdeni
Oct 17, 2021Copper Contributor
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.
I added some vba code copied from the internet but it didn't work. I'm beginner in vba.
- HansVogelaarOct 17, 2021MVP
See if this does what you want.
- chamseddine_hamdeniOct 17, 2021Copper Contributorthis is working. Thank you very much for your help