So I have two sheets. Sheet 1 is where the changes are made. Sheet 2 is simply Sheet 1 with a different filter on it (specifically on column F). Is it possible for Sheet 2 to autofilter when Sheet 1 is changed?
Sheet 2 is linked to Sheet 1 (I basically copied and pasted the contents of sheet 1 into sheet 2 as a link - I've never done it before, but from what I see each cell = the sheet 1 cells)
If there's easier way to do this, I'm happy to consider. I needed the contents of Sheet 1 only if the condition of column F <> 'No' but Sheet 1 filters etc need to remain the same.
I did this
Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("Sheet3").AutoFilter.ApplyFilter
End Sub
But that doesn't seem to work with changes on sheet 1 that well for some reason.