Conditional printing based on cells greater than zero

G

Guest

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

David Hilberg

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

- David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NumberFormat for small non-zero numbers? 2
Conditional Formatting 1
count the number of rows with entries greater than zero 1
Copy rows if greater than zero 3
Blank Cells vs. Zero Values 2
Countif and values greater than zero for a named range 1
Conditional Minimum formula 3
Last cell in column greater than zero? 7

Top