Oct 17 2021 04:25 AM
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
Oct 17 2021 05:29 AM
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.
Oct 17 2021 05:57 AM
Oct 17 2021 06:30 AM
SolutionSee if this does what you want.
Oct 17 2021 10:38 AM
Oct 17 2021 06:30 AM
Solution