Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I auto refresh a column that has an auto filter in place
I am workin in Excel, and have an issue with filtering a column
automatically. The column is fed by formulas in the cells. I want to auto filter the column (non-blanks) and this works fine. However, when the input data is changed, and the column fills with new values, the filter is not automatically re-applied, and I have to manually re-apply it. How can I automize this process? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I auto refresh a column that has an auto filter in place
This example uses data in column A. The macro will automatically refresh the
autofilter whenever formulas are calculated: Private Sub Worksheet_Calculate() Application.EnableEvents = False Set r = ActiveCell Columns("A:A").Select Application.CutCopyMode = False Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="<" r.Select Application.EnableEvents = True End Sub Note that this is Event code and goes in the worksheet code area, not a standard module. -- Gary''s Student - gsnu200761 "Pastal" wrote: I am workin in Excel, and have an issue with filtering a column automatically. The column is fed by formulas in the cells. I want to auto filter the column (non-blanks) and this works fine. However, when the input data is changed, and the column fills with new values, the filter is not automatically re-applied, and I have to manually re-apply it. How can I automize this process? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
refresh auto filter | Excel Worksheet Functions | |||
Auto sum returns a 0 value in place of sum of values in column. | Excel Discussion (Misc queries) | |||
How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions |