How to print only selected areas from an order sheet I created.
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 |
How to print only selected areas from an order sheet I created.
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 |
How to print only selected areas from an order sheet I created.
?B?U3RldmUyazY3?= 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 I accomplished this by assigning this macro to a button on my sheet: Sub PrintIt() Columns("A").AutoFilter Field:=1, Criteria1:="<" ActiveSheet.PrintOut Columns("A").AutoFilter End Sub -- David |
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com