Printing

  • Thread starter Thread starter Paul M
  • Start date Start date
P

Paul M

I have a worksheet as follows
Column A Description
Column B Monthly Sales
Column c Year to Date Sales

If column C is Zero, I don't want any of that line printed.

Is this possible

Regards

Paul
 
Paul M said:
I have a worksheet as follows
Column A Description
Column B Monthly Sales
Column c Year to Date Sales

If column C is Zero, I don't want any of that line printed.

Is this possible

Not directly. You need to hide the lines before printing. To do this
manually, you can use Autofilter. To do it automatically you would need a
macro.
 

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

Sum with multiple conditions 6
Choice of Formula 4
Triple IF? 2
How to sum by month 8
Averaging, but excluding zeros 5
match and sort two different tables 2
HELP ON SUM - REQUIRED 8
EXCEL FUNCTION 1

Back
Top