Printing only certain rows?
 

This might be a simple question to answer for some of you but I am stuck
at this point. Here's my question...

I want to set up a simple ordering sheet for my heating and air
conditioning business. There are several hundred different types of
products that we use on different jobs. What I am wanting to do is set
up in excel a way to insert a check mark box in say column A next to
each different type of product that we order. Also, I will data enter
all of the different products that we order. I want to set it up so
you can put a check mark next to the type of product we order (the ones
with check marks ideally would be the only ones to print). Then the
products that I do not put a check mark next to do not print. I am
hoping that makes sense. If anyone can help me I would surely
appreciate it.

Sam


--
sambles28
------------------------------------------------------------------------
sambles28's Profile: http://www.excelforum.com/member.php...o&userid=30606
View this thread: http://www.excelforum.com/showthread...hreadid=502586

Printing only certain rows?
 

Several ways:
use datafilterautofilter
hide the rows
filter to another sheet and print that
etc.

--
Don Guillett
SalesAid Software

"sambles28" wrote
in message ...

This might be a simple question to answer for some of you but I am stuck
at this point. Here's my question...

I want to set up a simple ordering sheet for my heating and air
conditioning business. There are several hundred different types of
products that we use on different jobs. What I am wanting to do is set
up in excel a way to insert a check mark box in say column A next to
each different type of product that we order. Also, I will data enter
all of the different products that we order. I want to set it up so
you can put a check mark next to the type of product we order (the ones
with check marks ideally would be the only ones to print). Then the
products that I do not put a check mark next to do not print. I am
hoping that makes sense. If anyone can help me I would surely
appreciate it.

Sam


--
sambles28
------------------------------------------------------------------------
sambles28's Profile:
http://www.excelforum.com/member.php...o&userid=30606
View this thread: http://www.excelforum.com/showthread...hreadid=502586