View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Print rows with special value only

Hide the rows without quantity.
Use Autofilter:

http://www.contextures.com/xlautofilter01.html

--
Gary''s Student - gsnu200835


"STIG" wrote:

I have a table with many rows. I place quantity in one column for few rows.
How can I have ONLY the rows with quantity printed?