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.

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

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

"Dave Peterson" wrote:

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

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

kintzldj wrote:

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

"Dave Peterson" wrote:

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


--

Dave Peterson