S
SteveDB1
Hi all.
Is there a way to filter two worksheets simultaneously?
I've recorded the following autofilter:
Sub FilterC()
ActiveSheet.Range("$A$3:$J$29").AutoFilter Field:=6, Criteria1:="<>"
Sheets("Sum").Select
ActiveSheet.Range("$A$8:$F$13").AutoFilter Field:=1, Criteria1:="<>"
End Sub
It's not generic enough to use for all instances of my desired goal. And
none of the books we have discuss this topic.
I.e., I want to select a filter criteria on one worksheet, and have it set
the identical filter on the other worksheet.
Thank you.
Is there a way to filter two worksheets simultaneously?
I've recorded the following autofilter:
Sub FilterC()
ActiveSheet.Range("$A$3:$J$29").AutoFilter Field:=6, Criteria1:="<>"
Sheets("Sum").Select
ActiveSheet.Range("$A$8:$F$13").AutoFilter Field:=1, Criteria1:="<>"
End Sub
It's not generic enough to use for all instances of my desired goal. And
none of the books we have discuss this topic.
I.e., I want to select a filter criteria on one worksheet, and have it set
the identical filter on the other worksheet.
Thank you.