View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
13 Whistling Pigs 13 Whistling Pigs is offline
external usenet poster
 
Posts: 1
Default 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?