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.


--
smplogc
------------------------------------------------------------------------
smplogc's Profile: http://www.excelforum.com/member.php...o&userid=33887
View this thread: http://www.excelforum.com/showthread...hreadid=537072