FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
Hello,
I have a formatting macro for daily reports that puts everything into a format that is easy to read, but I have one last step before I can consider it complete. I'd like the macro to optimize the page breaks to fit the most data onto each page without cutting off a user's data, so I can keep it all together, and then add the same header from the top of the entire report at the top of each page so everyone can understand what the data means without having to flip to page 1 (the report is printed and posted for employees to see how they did the previous day). I've been doing this last part manually, and that can be very tedious when the report will hit 40+ pages.
This is an example of what the data looks like before I manipulate page breaks and headers:
And this is what it looks like after I make my adjustments:
Does anyone know of a way to automate the page breaks, having them go down as far as possible and setting below the Total row for the bottommost user, and copying the header from Row 5 and pasting into the blank row above the user on each successive page?
I have a formatting macro for daily reports that puts everything into a format that is easy to read, but I have one last step before I can consider it complete. I'd like the macro to optimize the page breaks to fit the most data onto each page without cutting off a user's data, so I can keep it all together, and then add the same header from the top of the entire report at the top of each page so everyone can understand what the data means without having to flip to page 1 (the report is printed and posted for employees to see how they did the previous day). I've been doing this last part manually, and that can be very tedious when the report will hit 40+ pages.
This is an example of what the data looks like before I manipulate page breaks and headers:
And this is what it looks like after I make my adjustments:
Does anyone know of a way to automate the page breaks, having them go down as far as possible and setting below the Total row for the bottommost user, and copying the header from Row 5 and pasting into the blank row above the user on each successive page?