+ Reply to Thread
Results 1 to 5 of 5

How Can I create Dynamic Pivot Table Title?

  1. #1
    Registered User
    Join Date
    06-07-2014
    MS-Off Ver
    Excel 2010
    Posts
    10

    How Can I create Dynamic Pivot Table Title?

    I have a pivot table without report filter and I set insert page break after one of my selected row labels.

    I also would like when I print, these row Labels become the title of these pages at the same time.

    What should I do?

    below is my actual File:
    Untitled.png

    However I would like when I click on print or save as pdf will print all pages as one file and each Center that I have set page break for, in separate page and add that specific center as its title:

    please all attachments for more details:

    test_Page_1.jpg
    test_Page_2.jpg
    test_Page_3.jpg
    test_Page_4.jpg
    Last edited by niloufar; 06-08-2014 at 10:56 AM. Reason: Added more details about my question

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: How Can I create Dynamic Pivot Table Title?

    I'm not entirely clear what you're asking. Can you provide a sample workbook with an example of what you want to happen?
    Last edited by k64; 06-08-2014 at 01:24 AM.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How Can I create Dynamic Pivot Table Title?

    Hi and welcome to the forum

    Also not too clear on what you want, but I hink you need to go into the print settings and set the header rows that you want to have repeated on each sheet
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    06-07-2014
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How Can I create Dynamic Pivot Table Title?

    Thank you so much for reply. It is very hard to explain, but I will try my best.

    1- First I have added more details and pictures to my question.
    2- I have two options : one to add Report Filter or just include it in my Row label.

    either ways I would like to print or save as pdf my whole table in one file that has separated my Report filter is separate pages also recognize my filter or my specific row label as its own title.

    For example if my filter includes 3 items; so between item 1, item2, and item3 set break page and on item1 page the title or header or caption shows item1 and on item2 page the title shows item2 and the same thing for item3.

    becuase in future we may add more items and I would like titles dynamically change base on my specific row label or report filter.
    Last edited by niloufar; 06-08-2014 at 11:08 AM.

  5. #5
    Registered User
    Join Date
    06-07-2014
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How Can I create Dynamic Pivot Table Title?

    Thank you so much for reply. It is very hard to explain, but I will try my best.

    1- First I have added more details and pictures to my question.
    2- I have two options : one to add Report Filter or just include it in my Row label.

    either ways I would like to print or save as pdf my whole table in one file that has separated my Report filter is separate pages also recognize my filter or my specific row label as its own title.

    For example if my filter includes 3 items; so between item 1, item2, and item3 set break page and on item1 page the title or header or caption shows item1 and on item2 page the title shows item2 and the same thing for item3.

    becuase in future we may add more items and I would like titles dynamically change base on my specific row label or report filter.


    Quote Originally Posted by FDibbins View Post
    Hi and welcome to the forum

    Also not too clear on what you want, but I hink you need to go into the print settings and set the header rows that you want to have repeated on each sheet

+ 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. [SOLVED] Formula To Create A Dynamic Title While Using Filters
    By Charmymay in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-17-2013, 02:46 PM
  2. Dynamic title on pivot chart
    By PKDJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2013, 03:27 AM
  3. Need dynamic title in pivot table in excel web access
    By SJMaye in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-12-2010, 01:36 PM
  4. how to create dynamic hyperlinks to a cell of a pivot table
    By ramonsojos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2010, 05:31 PM
  5. Using dynamic range to create pivot table
    By cursednomore in forum Excel General
    Replies: 3
    Last Post: 06-13-2006, 04:40 PM

Tags for this Thread

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