Conditional page breaks?

[Guest]

Is it possible to setup up a macro for conditional page breaking? Let's
say I have an employee listing sorted by department name. When the
Department name changes I would like a page break. Could this be possible?
The list is too large to manually insert the page breaks. Thank you ahead of
time.

 

[Dave Peterson]

Maybe you could use Data|Subtotals.

You get an option to add page breaks.

And when you add more info, just remove the data|subtotals, sort your range and
reapply.

 

[Guest]

Thanks, I tried this. Unfortunately when you try to remove the subtotals
it also removes the page breaks.

 

[Dave Peterson]

Right. So when you reapply the data|subtotals, you make sure you add the page
breaks back.