Posts by siweltj

Re: Automatically Refresh Autofilter

Thanks for the help, this gets me close but not quite want I want. I have the following code in my data source worksheet

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("ACCRUALS DETAIL").Activate
Selection.AutoFilter Field:=3, Criteria1:="<>"
End Sub

and the following in worksheet that provides me the filter:

Sub FilterTo1Criteria()


With Sheet5
            .AutoFilterMode = False
            .Range("C2:C501").AutoFilter
            .Range("C2:C501").AutoFilter Field:=3, Criteria1:="<>"
    End With
    
Selection.AutoFilter Field:=3, Criteria1:="<>"
    
End Sub

With this any time I make a change in the data source worksheet the worksheet changes to my filter worksheet. I want to be able to make multiple changes in the datasource worksheet without being redirected. The filter worksheet is a summary worksheet that may or may not be reviewed by the person making changes in the datasource sheet. However, upon viewing the filter worksheet I always want it to display the correctly filtered items.

The above code works well but that it redirects me to the summary sheet with each and every change on the datasource sheet.

I have a worksheet set with Autofilter. This worksheet is populated by formulas taking data entered on another worksheet.

I want the Autofilter for the first worksheet to automatically refresh each time I view that worksheet or as data is entered on the supporting worksheet.

Any suggestions?