Imitating Auto Filter

[braidp]

I have a table of data that I need to then auto filter to return a subtotal across 11 columns and the works fine, however what I would really love is a front page to this data that automatically displays set criteria I would normally select to auto filter by.

For example when I auto filter to a Region I can view the average completion across the 11 columns, then if I want to auto filter by the UK I can then select UK as the measure and it returns the average using the subtotal.

What I would love is an overview constantly on a separate worksheet that would display the subtotal automatically of about 8 different filters

Is this easily possible?

Many thanks

 

[Mentor82]

Hi,
Have you tried excel's built-in advanced filter functionality? Withim this functionality you can set many different filter at a time.

Regards,
Sebastian

 

[braidp]

Thanks mentor82 I’ll take a look at advanced filters....and see how it works as never used it before