Insert a page break for each new record

S

strugglin'

I have a spreadsheet with multiple columns, and one of the
columns contains duplicate entries. I have re-sorted the
table by this column, and now I would like to print the
table, but I'd like a new page to commence with each new
record.
I realize I can do this in Access, but this spreadsheet is
for someone else with minimal pc skills, so I want to keep
it simple for them by just adjusting the print settings.
Thanks.
 
F

Frank Kabel

Hi
this would be only possible with VBA / a macro. Is this a possible
solution for you?. If yes you may provide a little bit more detail
about your data structure. Which column defines that a new record
starts
 
G

Gord Dibben

strugglin

Sub InsertBreak_At_Change()
Dim i As Long
For i = Selection.Rows.Count To 1 Step -1
If Selection(i).Row = 1 Then Exit Sub
If Selection(i) <> Selection(i - 1) And Not IsEmpty _
(Selection(i - 1)) Then
With Selection(i)
.PageBreak = xlPageBreakManual
End With
End If
Next
End Sub

Select to the bottom of your sorted column then run the macro.

Can take some time with many rows and breaks.

Gord Dibben Excel MVP
 
D

Dave Peterson

You could use Data|Subtotals.

On that dialog, there's an option to insert a page break between groups.

(new record means new group???)
 
S

Strugglin'

Thanks for all the suggestions...problem solved.
-----Original Message-----
You could use Data|Subtotals.

On that dialog, there's an option to insert a page break between groups.

(new record means new group???)



--

Dave Peterson
[email protected]
.
Click to expand...
 
Top