How can I filter multiple sheets with an specific value to filter. For example the Country name....
How can I filter multiple sheets with an specific value to filter. For example the Country name....
Loop through each worksheet and apply the filter to the specific range for each worksheet. Example:
![]()
Sub Example() 'Made a lot of assumptions since you gave no actual information Dim ws As Worksheet For Each ws In Worksheets With ws .AutoFilterMode = False .Range("A1:A" & .Range("A" & Rows.Count).End(xlUp).Row).AutoFilter 1, "Your Country" End With Next ws End Sub
If you are happy with my response please click the * in the lower left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks