Print only desired rows
 

I use a spreadsheet to do material quotes. The spreadsheet is about 500 rows
of items. I usually only quote up to ten things at once. I only want to print
the rows if the quantity column is 0. I have thought of using LOOKUP or IF
functions on a second sheet to copy those rows and then I could easily print
that sheet instead, but I can't quite get it to work. Any ides beside
manually going through and hiding 490 rows every time I quote a customer?

Print only desired rows
 

Use an Autofilter under the data menu. this will hide the rows all at once.

Define the data area (500 rows) as having the defined name Database. Then
apply the autofilter and use a custom filter on the quantity column for
quantities 0.

--
Regards,
Tom Ogilvy


"13 Whistling Pigs" <13 Whistling wrote in
message ...
I use a spreadsheet to do material quotes. The spreadsheet is about 500
rows
of items. I usually only quote up to ten things at once. I only want to
print
the rows if the quantity column is 0. I have thought of using LOOKUP or
IF
functions on a second sheet to copy those rows and then I could easily
print
that sheet instead, but I can't quite get it to work. Any ides beside
manually going through and hiding 490 rows every time I quote a customer?