Help with Advance Filter and Work_SheetChange Macro

[shaht96]

I currently have 2 sheets, Data and Data Report.
I am using an advanced filter on Data Sheet based on an input in Data Report Sheet.

I am using the code below in my Data Sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Range("OutOfSequence[[#All],[WaveNumber]:[Out of Order?]]").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range _
("AO1:BZ2"), Unique:=False


End Sub

Which works fine, but it only works when I click back in the Data Sheet and click on a cell in that sheet. Hitting F9 doesn't work either.

I would like for the above Macro to run automatically when I change the input value in Data Report, without having to click back in the Data sheet.

Thank you.