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?
Bookmarks