morning all.
I'm doing some data verification and have set up two worksheets with filters
on both of them.
I've also set up a subtotal worksheet function to verify that my data
matches.
So that I can avoid going back and forth to keep adjusting my filter for
each sheet, is there a way that I can "link" the two filters to be as a
single filter for both sheets?
I.e., I'd like to just set the filter on one sheet to adjust the filter on
the other worksheet as well.

Thank you.
Best.
SteveB.
I'm using XL2007.