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.

kintzldj wrote:

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