title: When the value in a cell changes change the filter on a pivot table
body: <p>I have been reading around for a bit and reached the ask SO point. I have a drop down selector in excel that lets me change names and when the name is changed, the value in "C3" is changed (c3 references another cell on another sheet if that matters) and when the value in "C3" changes I want a pivot table on another sheet (sheet6 for now) to update its filter on territory id to reflect the new value of "C3".</p>
  
  <p>It sounds like an event to me, so I went digging around and found out VBA has events (yay!), but I have been unable to get my event to actually do anything. The code I have there works when I run it as a macro, but I would really like it to automatically run everytime the value in cell "C3" changes.</p>
  
  <p>Here is what I am trying so far:</p>
  
  <pre><code> Sub Worksheet_Change(ByVal Target As Range)
   If Not Application.Intersect(Target, Sheets("Current Status").Range("C3")) Is Nothing Then
  Sheets("Sheet6").PivotTables("PivotTable5").PivotFields("territory_id"). _
      ClearAllFilters
  Sheets("Sheet6").PivotTables("PivotTable5").PivotFields("territory_id").CurrentPage _
      = Sheets("Current Status").Range("C3").Value
   End If
   End Sub
  </code></pre>
  
  <p>Update: I have found that if I put the above code in the sheet section (sheet 2) instead of in a new module I can get it to run if I physically enter the code and then hit enter. Now I am wondering if there is a way to make it do it without me having to manually enter the value and hit enter. I just want to be able to use my drop down menu to select a new name and when the value in c3 changes due to the drop down selector update the pivot table.</p>
  
  <p>Thank you as always SO.</p>