software

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
quot;pull sheetquot; 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

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

quot;Steve2k67quot; wrote:

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

=?Utf-8?B?U3RldmUyazY3?= wrote

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

I accomplished this by assigning this macro to a button on my sheet:
Sub PrintIt()
Columns(quot;Aquot;).AutoFilter Field:=1, Criteria1:=quot;lt;gt;quot;
ActiveSheet.PrintOut
Columns(quot;Aquot;).AutoFilter
End Sub

--
David