+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

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

    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
    Don't forget to rate 1 who helped u, using "Star"

  2. #2
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    173

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

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Loop through pivot table field and paste results in next row
    By DCLT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2015, 03:17 PM
  2. How to filter a field in pivot table using two filters
    By Bluemini in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2015, 12:41 AM
  3. Replies: 0
    Last Post: 03-20-2015, 11:39 AM
  4. [SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  5. [SOLVED] Top 5 Pivot table filter by inner row field count
    By theThirdMan in forum Excel General
    Replies: 1
    Last Post: 12-12-2012, 02:38 AM
  6. Pivot table: field both as filter and row type
    By boooinky in forum Excel General
    Replies: 4
    Last Post: 03-28-2012, 10:35 AM
  7. Create a list from Pivot table field rows
    By sayeamans in forum Excel General
    Replies: 3
    Last Post: 12-04-2009, 09:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1