View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Erik T
 
Posts: n/a
Default Hide all values in a row if value is 0

I am putting together a forecast sheet for part requirements and with so many
parts to deal with I would like to set it up so that anytime the required
amount is 0, then the entire row is hidden. Currently I have a simple formula
to just show a blank cell. It is time consuming to review 300 P/N when I may
only need 14 P/N that week. How can I go about hidding the entire row in a
formula?

Thank you,

Erik