Printing

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
 
P

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

Top