Conditional page breaks?

K

kintzldj

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.
 
D

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.
 
K

kintzldj

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

Dave Peterson

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