Pivot Table problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top