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