Thank you, Dave. That was very helpful!

"Dave Peterson" wrote:

Maybe you could use data|subtotals (xl2003 menu system) to get subtotals -- make
sure you select page break between groups.



cbuck wrote:

It sounds simple enough, but I haven't been able to find any information.

I need to insert a page break at each change of value in column B. For
example:

Column A = Name
Column B = Department

I need to insert a page break every time the department changes.

Any help would be greatly appreciated!

--

Dave Peterson