Automated Dynamic Printing Area?

Is this possible?

Say you have a 200 row spreadsheet with various functions being performed in the bottom cells. If only the first few rows are filled with data, when printed, all the empty rows that won't fit on on the first page will automatically be omitted, except for those important bottom rows. So the first page will have the rows filled with data, plus empty rows to fill out the page, and the bottom rows.

If there are one too many filled rows to fit on one page, then a second page will be printed with enough empty rows to fill the page, with the bottom rows included at the bottom of the second page.

In other words, I want print jobs to be scaled in terms of pages based on filled rows, with important bottom rows automatically added at the end of the last page of the job.