printing specific lines

[Jim Office Supply Store Owner]

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...

 

[Sheeloo]

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...