Excel 2007 : Refresh Autofilter

Originally Posted by nasfric

Since i've created a table from cell M43 to W8803. The cells along column W appear either "True" or "False". I want the table appears only "True" automatically after I enter the input data.

Assuming the range containing changed input- data need is B43:B8803 (plz adjust it corresponding to your case),

Right click on your sheet name, choose view code and paste the code below. This will enable auto-refresh.

Private Sub Worksheet_Change(ByVal Target As Range)
        If Intersect([B43:B8803], Target) Is Nothing Then Exit Sub
    
        Application.EnableEvents = False
        Application.ScreenUpdating = False
     
        Me.AutoFilter.ApplyFilter
    
        Application.EnableEvents = True
        Application.ScreenUpdating = True
    
End Sub