I do AutoFilter to create a subset of data. Then I want to create a PivotTable on the *subset* and do a count. I then realize PivotTable doesn't work on the subset even though the rows are hidden. It works on the entire database. To circumvent this, I do copy/paste of the subset and create the PivotTable based on the pasted version. If the range for the subset is huge, it may not be efficient to do copy/paste. What is a more efficient way to achieve the same result?

Thanks.

Epinn