I have a column on Sheet 1 that has a filter option, when the user updates the filter I need the filter to update on multiple sheets.
The other sheets are fed by the sheet on field input with a simple formula +Sheet1!A4 for example.
I have successfully got the autofilter function working on a single sheet but unable to replicate this on the other sheets.
This is how I have applied the auto filter on sheet 1 on the view code option
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.autofilter.ApplyFilter
End Sub
I have used the same code on sheet 2 etc. but it doesn't apply is this because the subsequent sheets are not actually changing?
Bookmarks