Hi everyone
I have a list of student names, M/F, D.O.B., Test results
etc. sorted by their assigned classroom number. Rooms
numbers can vary in sequence and total off i.e.
4,5,6,9,12,16, etc.etc.
The number of students in each class can also vary but a
classroom will always fit on the one page.

I can find the starting row of each room by using a
helper column and inserting a blank row and page break.

What I would like to do is move the starting row of room
5 down to row 38 (start of page 2 landscape format).
Then move room 6 down to row 74 (start of page 3
landscape format) and so on until and including the last
room number, to end up with a classroom on each page with
spare blank rows for teachers use.

The page size ,margins, headers and footers have been set
previously.

Season Greetings to all.
Hope you can help.

TIA

Bob C