Filter Refresh

D

Danny

Excel 200

When I have a filter such as "NonBlank" - I enter data into the cell
The filter doesn't refresh unless I re-select filter "NonBlank"

Is there a way to make the filter refresh as soon as data is entered
That way the row is no longer visible
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remembering the same filtering criteria 13
Is it possible to just act on the filtered data 2
Refreshing Pivot table 1
VBA filter and sorting 1
VB Macro for Pivot Filter Function 0
filter function 0
On Double Click - Filter Transactions to New WorkSheet 0
= cell above last entered data 9

Top