On Sep 29, 8:43*pm, SteveDB1
wrote:
Ok, as a follow up, I did find, and try Advanced filtering.
It does not work for my desired purpose.
I tried selecting the range of interest on my detail sheet, and then the
criteria range on my summary sheet. It only allowed one item. No matter what
I selected on my summary sheet it did not change the filtered values of my
detail sheet.

I then reversed my process to set the range of interest on my summary sheet,
and criteria range on my detail sheet. Same-- nothing changed.

So, my next question then goes to:
Can filtering two worksheets linked together with one sheet being the
controller work?
Thank you.
SteveB.

I have the same issue and would appreciate any help at all on using
the filters on one sheet to control the same filters on other sheets.