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.

Hi A2Irish

How does one determine whether an order has been placed? Have you considered using Word's mailmerge capacity to extract only the ordered records for printing?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]