excel 2000 macros
 

need excel 2000 macro to insert a page break on column when changes aaa to bbb

excel 2000 macros
 

Try Data|Subtotals.

There's an option to include page breaks between changes.

And you get subtotals for the columns you choose!

JJIM_RR wrote:

need excel 2000 macro to insert a page break on column when changes aaa to bbb

--

Dave Peterson

excel 2000 macros
 

ThankYou Dave, work great and even did more for me by adding my count.

"Dave Peterson" wrote:

Try Data|Subtotals.

There's an option to include page breaks between changes.

And you get subtotals for the columns you choose!

JJIM_RR wrote:

need excel 2000 macro to insert a page break on column when changes aaa to bbb

--

Dave Peterson