View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteveDB1 SteveDB1 is offline
external usenet poster
 
Posts: 414
Default filter two worksheets w/ the first as a controller

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.