I created an order form for salespeople to fill in with about 200 products. In each row, I have an item number, product description, a space to fill in quantity, and a formula for the subtotal. I'd like to be able to print each order in one page by hiding all of the rows that don't have a quantity filled in. This would show only rows with items that are being ordered. Does anyone know how I can do this?
Thanks for your help!
Bookmarks