Print only cells with values
 

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???