I'm a basic excel user. I am trying to set up an order form that will have in excess of 500 individual line items that could be ordered. How do I set up a print algorithm that will only print the lines where an order has been placed; I don't want to print out the entire list each time, many orders will only have one or a few items ordered.

Thanks in advance for any help.