Macro that inserts page breaks into a monthly report when name changes occur in column C

[Prostho_LMJR]

The attached monthly report is exported from another system (non-MS) and will contain the names of 250-300 individuals. I want a macro that will automatically insert page breaks in column C when the name changes versus doing it manually myself. The size of the report would make manual insertion counter-productive.

[dangelor]

Possibly...

Please Login or Register  to view this content.

[ByteMarks]

another approach

Please Login or Register  to view this content.

[Prostho_LMJR]

Thank you for the response and help.

The macro works to a certain extent. It inserts a page break BELOW the "Single restoration codes" heading (see attachment).
Is there a way to have the page break inserted above the row so that the heading is included with the next student's name?

[dangelor]

Possibly...

Please Login or Register  to view this content.