Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an excel 2007 spreadsheet I use to give to my customers for filling
out orders. It lists the product and quantity and total on each line. I wondered if there was a way to print only the lines with a quantity entered when completed. It would save the customer a ton of paper... |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Use Data|Auto Filter and Filter on Quantity and exclude blank cells.
You can provide a button which can do this through a macro and then print.. You can record the macro yourself and attach to the button... Send me mail with sample file if you need help... "Jim Office Supply Store Owner" wrote: I have an excel 2007 spreadsheet I use to give to my customers for filling out orders. It lists the product and quantity and total on each line. I wondered if there was a way to print only the lines with a quantity entered when completed. It would save the customer a ton of paper... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing a Lines of Data | Excel Discussion (Misc queries) | |||
not printing lines? | Excel Worksheet Functions | |||
printing onto multiple lines | New Users to Excel | |||
printing grid lines when grid lines is checked | Setting up and Configuration of Excel | |||
Print only lines that have a value in a specific colum | Setting up and Configuration of Excel |