Pivot Table problem

A

awwtau

I have automated a pivot table through a macro. I need to automate another
pivot table using the same data sheet but only certain rows. I could delete
off the rows i don't need then create the pivot table but the rows I need
might not always be in the same position so would not be realible when it is
automated.
Is there a way to filter out rows from the data sheet and then use the
filtered rows to create the pivot table using Vb or some other means?

Thanks for your help.

Alan
 
T

Tom Nichol

Awwtau,

In the Pivot Table "layout", you can perform limited filtering by moving
selected fields to the "Page" area. When table has recalculated, you can
open the drop down arrows of those fields to limit selection only to rows
that match. Optionally, you could sort your data so that the rows that you
wish to exclude are at the bottom, then highlight the column headers and only
the rows which you wish to use, then create the Pivot Table.
 
Top