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 don’t 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???