macro to insert page breaks

I have attached an example of the raw data and the pivot table I would like to print. We need to print out each company's invoice details and attach them to the check. We only need to print out the information in the pivot table. The only way I know how to print each company on a different sheet is to insert page breaks. There are over 400 lines of data on the actual pivot table. This would take ages for me to manually insert the breaks. Is there a way to write a macro?

Thanks,
Jennifer

Give this a try. You may want to modify it to get the page breaks exactly where you want them but it will give you a start.

Please Login or Register  to view this content.

HTH

Thank you so much. We will try this right now.