View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default Use array to do advanced filter?

Jim,
Thanks for your reply. I will have to check with the person sending me
the data, they may or may not want to change how they do it.
I'm interested in finding out how to use a Pivot Table to filter data.
I've used them a little, but always to change the data display, never
to "hide" some of the data. Can you point me in the right direction on
how they can be used that way?