Add a Page Break at Each Change in Customer
October 20, 2021 - by Bill Jelen
Problem: My data is sorted by customer in column A. I want to put each customer on a different page.
Strategy: The easiest way to do this is to add a subtotal by using the Data, Subtotals command. In the Subtotal dialog, you can choose to have a page break between groups.