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.

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.