+ Reply to Thread
Results 1 to 1 of 1

Adding a surrounding template to Pivot Table's Report Filter Pages

  1. #1
    Registered User
    Join Date
    03-06-2018
    Location
    USA
    MS-Off Ver
    Always up to date.
    Posts
    18

    Adding a surrounding template to Pivot Table's Report Filter Pages

    I need to generate time sheets for many individuals to sign off on. I'm able to do this using a Pivot Table and the "Show Report Filter Pages" feature.

    However, I need to include certain things on these individual reports, such as company name and info, the word "Timesheet", some formula cells that will update with the pay period range, and a signature and date line to sign. Unfortunately extra columns above and below a pivot table do not copy over when running the Show Report Filter Pages command. Is there any easy way to achieve such a template for every individual page to adopt?

    I am aware of the Header and Footer feature of Excel for printing, but it's a bit too limited for what I'm trying to do.

    Slightly separately, it seems that individual reports will not keep the row height set for all rows in the initial pivot table. That isn't as important, but is there a way to maintain those heights as well?
    Last edited by etudes; 02-10-2019 at 08:10 PM.

+ 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] Xl Crashing: Code to format after Pivot: Show Report Filter Pages.
    By saudi_red_neck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-01-2018, 06:03 AM
  2. Replies: 5
    Last Post: 12-27-2016, 04:24 PM
  3. Replies: 1
    Last Post: 11-05-2014, 04:29 AM
  4. Help with Pivot Tables Show Report Filter Pages
    By this1guy in forum Excel General
    Replies: 2
    Last Post: 10-12-2014, 02:32 AM
  5. How to Create Report Template for Excel Pivot Table
    By Oscar Martin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-16-2014, 09:45 AM
  6. [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
  7. Place a number filter on a report filter in a pivot table
    By reuben.doetsch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2010, 12:41 PM

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