title: Automatically refresh autofilter - VBA or not
body: <p>I have been trying and failing to find a code that refreshes the auto-filter (criteria for filter is in column A) whenever new data is entered into column C (which is the root variable for values in A,B &amp; D) </p>
  
  <p>Any help would be MUCH appreciated. </p>
  
  <p>Here is the code that I have found in other threads, but I can't get it to work. </p>
  
  <pre><code>Private Sub Worksheet_Calculate() 
  
             If Me.FilterMode = True Then 
      With Application 
          .EnableEvents = False 
          .ScreenUpdating = False 
      End With 
  
      With ActiveWorkbook 
          .CustomViews.Add ViewName:="Mine", RowColSettings:=True 
          Me.AutoFilterMode = False 
          .CustomViews("Mine").Show 
          .CustomViews("Mine").Delete 
      End With 
  
  
      With Application 
          .EnableEvents = True 
          .ScreenUpdating = True 
      End With 
  End If 
  End Sub 
  </code></pre>