Hello, was wondering if anyone can help with this problem..

I am using the subtotals feature and it is grouping all different customers in range A:A. When I do this the page breaks are all wrong.

For example, there will be 3 rows for customer A and it will put 2 of them rows on one page and 1 on the next page.

Has anyone come across this problem before?

Would appreciate any help at all.

Thanks

John