I have created a worksheet for filling order, and some orders may have as
many as 500 items, which are not all available at one time, and some order
only have maybe 5 lines. So, I have created a worksheet that on Sheet 1
you input the complete order. On Sheet 2, you enter in the items which are
being shipped today, and it calculates a total for that shipment. Sheet 3
you enter the items which are being shipped the next day and so on, and all
of these worksheet have links to previous worksheets to obtain info.

What I am trying to accomplish is to print only the lines which have
information on them, without hiding the blank lines, or changing the print
area each time. Sheet 2 has 500 lines of formulas with links to Sheet 1
and if Sheet 1 only has 10 lines of info, I dont need to print 12 blank
pages. I have it set that if the cell equal zero, cell is blank.

Is there any way of accomplishing this???