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