Page Breaks based on cell data
I'd use data|subtotals.
There's an option to insert page breaks between groups on that dialog.
And I could even get subtotals (counts, sums, averages,...) if I wanted them.
Josh Craig wrote:
Hi,
I was wondering if anyone knew how to create a macro to insert a page break
after a number of values in a column. For example:
Column A
Category
Cat
Cat
Cat
Dog
Dog
Sheep
Sheep
Sheep
I want to insert a page break in between cat and dog and in between dog and
sheep. Any ideas?
--
Dave Peterson
|