Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Conditional printing based on cells greater than zero

Is there a way to write a macro that will recognize and print only those cell
that meet certain criteria? In particular, I have a huge spreadsheet that is
used to order material. When a non-zero quantity is placed in a cell in
column C, it would be great if the program would print only that cell in
column C and the adjacent cells in D, E, F, and G. Any any given time, there
are many cells in column C that are non-zero, but also many that are zero. It
is a waste of paper and time to have to print the entire spreadsheet. Any
ideas? Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 84
Default Conditional printing based on cells greater than zero

Use autofilter. Before printing, select "NonBlanks" from the drop-down
menu. After printing,
select "All".

- David

dillon wrote:
Is there a way to write a macro that will recognize and print only those cell
that meet certain criteria? In particular, I have a huge spreadsheet that is
used to order material. When a non-zero quantity is placed in a cell in
column C, it would be great if the program would print only that cell in
column C and the adjacent cells in D, E, F, and G. Any any given time, there
are many cells in column C that are non-zero, but also many that are zero. It
is a waste of paper and time to have to print the entire spreadsheet. Any
ideas? Thank you.

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
CONDITIONAL FORMAT BASED ON 2 CELLS Steve_n_KC Excel Worksheet Functions 4 May 11th 07 10:38 PM
Printing cells with conditional formats & formulas John R. Excel Discussion (Misc queries) 2 May 31st 06 12:11 AM
conditional formating cells i Excel based on other cells values Elias Petursson Excel Worksheet Functions 3 May 23rd 06 06:45 PM
Conditional Formatting Multiple cells based on 2 cells Louis Markowski Excel Worksheet Functions 2 June 1st 05 05:26 PM
Printing of cells in Excel with conditional equations? Mic Kenney Excel Discussion (Misc queries) 1 June 1st 05 12:39 AM


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

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

About Us

"It's about Microsoft Excel"