Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default printing specific lines

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 364
Default printing specific lines

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing a Lines of Data Toby Excel Discussion (Misc queries) 3 June 28th 07 10:48 AM
not printing lines? jimfines Excel Worksheet Functions 0 February 2nd 06 02:07 PM
printing onto multiple lines jk New Users to Excel 2 January 10th 06 03:21 AM
printing grid lines when grid lines is checked fergos Setting up and Configuration of Excel 1 October 4th 05 02:55 AM
Print only lines that have a value in a specific colum Neve Setting up and Configuration of Excel 1 August 17th 05 12:31 AM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"