Morning all.
As I've read through the posts on filtering, I see a lot of discussion on
using the Advanced Filter to create a custom filter mechanism.
When I found my advanced filter in 2007, it only had one criteria option.
I then tried using it in "both directions" for my desired filter and it
didn't do what I needed.

Is there a way to set a filter to link the filter to two worksheets? I.e.,
if I pick an element on one page, both that page, and the other page become
filtered?

Thank you.
SteveB.