Auto page breaks 1

kastaman · Nov 1, 2001

In Excel 97, I have subtotalled the user's details.

Is there an easy script to automate the page breaks after a change in "fullname"?

Thanks,

Kastaman

Dreamboat · Nov 1, 2001

Data-Subtotals.
Use Fullname to subtotal by, then choose page break thing...

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

kastaman · Nov 8, 2001

Dreamboat - that is what I'm doing right now. The issue is that is takes time to place the page breaks.

I might have to do this in Access.

Kastaman

Dreamboat · Nov 8, 2001

No, no. In the SUBTOTALS box is an option to separate the groups using page breaks--it's automatic.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

kastaman · Nov 9, 2001

Thanks Dreamboat!! I can't believe I missed that one.

Kas

Dreamboat · Nov 9, 2001

LOL
LOL
Sure, and the rest of us never miss anything...
LOL
LOL

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Auto page breaks 1

kastaman

IS-IT--Management

Dreamboat

Instructor

kastaman

IS-IT--Management

Dreamboat

Instructor

kastaman

IS-IT--Management

Dreamboat

Instructor

Similar threads

Part and Inventory Search

Sponsor