This link should help you. http://www.contextures.com/xladvfilter01.html
Read sections a-c.

"Steve2k67" wrote:

I created an Order sheet of Our warehouse for a Vending Company. The Order
sheet lists all products and each route uses this sheet to request daily
product. I would like to create a print-out of just the product that is
requested (greater than a 0) so that I can use the print-out as sort of a
"pull sheet" to fulfill the order request. It would make reading and filling
the order so much easier if the products not checked could be omitted when
printing... I hope I made this understandable.
Thank You