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?
|