Forum Discussion
Solved
How to get Excel to automatically re-apply a filter when my table changes?
I filter the rows that are greater than 1% in the INFECTIOUS column. However, this filter is not reapplied when my data changes. How can I get it to reapply the filter automatically?
Perhaps more simple variant as here How To Automatically Reapply Auto-Filter When Data Changes In Excel? works in your case.
Perhaps more simple variant as here How To Automatically Reapply Auto-Filter When Data Changes In Excel? works in your case.
SergeiBaklan Is there away to make this work if it is the result of a formula which changes rather than manually changing the cell data?
That's quite old post. These date perhaps it's better to use FILTER function - Microsoft Support