Advanced Filter Query

[chriscarr]

Hi guys

I am hoping you can help on this one. I'm building a report which has 2 sheets "Summary" and "Data".

"Summary" contains a graph, summary table and an advanced filter. "Data" contains a variable number of rows in colums A to Q.

My problem is I want to run the advanced filters on the categories chosen on "Summary", the data to be filtered on "Data" and then the filtered results to show on the summary table.

I've got the last part sorted, the issue is getting the data to filter and remain on the "Data" sheet. To make it easier for non-Excel profecient people to use I've also created to VB buttons. 1 to run the filter and the other to reset the data.

The second button works fine however I ideally need the first button to advanced filter a varying number of rows of critera. Is there any way I can do this?

Thanks for your help in advance.

Chris

 

[pbornemeier]

If your Filter Criteria Headers start in cell A1 of the Summary worksheet and your Data Headers start in cell A1 of the Data worksheet, then this should work:

    Sheets("Data").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, _
        CriteriaRange:=Sheets("Summary").Range("A1").CurrentRegion, Unique:=False