Loop through Pivot Table Filter field from a List and create pdf

**Mysore** · 03-15-2016, 10:21 PM

Hi Folks

Below is the URL Link for the sample file . Looking for a VBA solution to filter the Pivot Filter field from a list and then create a pdf file.
In the attached file , I have a ProductList holding values A , B & C. I need pivot table to refresh for each corresponding values from the list and then generate a pdf file. If there is no data for a specific product Say C in my sample data, I want the sub routine to omit completely without creating any blank pdf.

Appreciate any help.

Thanks
Mysore

https://drive.google.com/file/d/0B7c...ew?usp=sharing

**danny2000** · 03-17-2016, 10:13 PM

Hi Mysore

Excuse my lack of understanding of pivot table terminology, but when you say 'filter the pivot filter field from a list' are you referring to the output which appears in a new tab each time you double click on a value in the data area of the table?

Whilst I use pivot tables I just do it without knowing all the correct terminology, so I'll need to understand perfectly if I'm going to help with this.

Loop through Pivot Table Filter field from a List and create pdf

LinkBack

Thread Tools

Rate This Thread

Display

Loop through Pivot Table Filter field from a List and create pdf

Re: Loop through Pivot Table Filter field from a List and create pdf

Thread Information

Users Browsing this Thread

Similar Threads

Pivot table: field both as filter and row type

Loop through pivot table field and paste results in next row

How to filter a field in pivot table using two filters

Between/greater than/less than filter options on manual filter field for Pivot Table

[SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?

[SOLVED] Top 5 Pivot table filter by inner row field count

Create a list from Pivot table field rows

Bookmarks

Bookmarks

Posting Permissions