Is there a way to automatically "reapply" a filter without a macro?

[jareed123]

Hello,

I have a very simple table where I would like to hide certain rows based from input criteria using a formula with a filter. It works, however you have to manually click on the "reapply" filter button every time you want to refresh. I know there is code to accomplish this, but the workbook has to remain macro free.

Any tips would be greatly appreciated!

 

[starl]

You have to click ReApply.

The other option (not really recommended, though because it can slow the workbook down) would be to use formulas to fill in the rows, instead of having a filtered table.