Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh Autofilter
Hello, smart friends
After changing of reference data the autofilter option is NOT refreshed. Is it possible to refresh the autofilter by activating the (filtered) sheet? Thanks in advance -- There are only 10 types of people in the world: Those who understand binary and those who don't. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh Autofilter
BKO,
You could use the calculate event: record a macro where you filter the data, and then pop it into the calculate event, along the lines of Private Sub Worksheet_Calculate() Range("E1:G20").AutoFilter Field:=1, Criteria1:="<0" End Sub When any data that is linked into the table is updated, the filter will be reapplied. Copy the code above, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Update the range address, field # and criteria.... HTH, Bernie MS Excel MVP "BKO" wrote in message ... Hello, smart friends After changing of reference data the autofilter option is NOT refreshed. Is it possible to refresh the autofilter by activating the (filtered) sheet? Thanks in advance -- There are only 10 types of people in the world: Those who understand binary and those who don't. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) |