I run reports a few times a month and would like to add a function to auto insert page break. The spreadsheet looks something like this:
Row 1 - 8 are headings
Row A9= last name, first name (columns B-U have data)
Row A10= last name, first name (columns B-U have data)
Row A11 = last name, first name SUM
So we may have 1 line of detail for 1000 lines of detail for an employee and then a sum underneath his name. I want to insert a page break after the sum information.
Any help would be appreciated.
Row 1 - 8 are headings
Row A9= last name, first name (columns B-U have data)
Row A10= last name, first name (columns B-U have data)
Row A11 = last name, first name SUM
So we may have 1 line of detail for 1000 lines of detail for an employee and then a sum underneath his name. I want to insert a page break after the sum information.
Any help would be appreciated.