SOLVED

Automatically re-apply filter

Occasional Contributor

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

4 Replies

@chamseddine_hamdeni 

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.
best response confirmed by chamseddine_hamdeni (Occasional Contributor)
Solution

@chamseddine_hamdeni 

See if this does what you want.

this is working. Thank you very much for your help