Hide row if cell is cell=0

[ossa]

Hi!

I`ve never used macros before. Could someone please show me how to make a macro, which hides every row between 6 and 359, if the cells FM6:FM359 are 0. Or just removes for example row 50, if cell FM50=0. Thanks for every answer.

Ossa

[venkat1926]

why not just sort data according to column FM descending
0's will be pushed to the bottom and you can hide or remove those rows.

[ossa]

I am not sure I understand what you mean. I have a list of products (upper-left corner) of a sheet. I am entering a value for these products, and I need to make a receipt of those products which has been sold. The thing is, I would like to only have those products which actually has been given out, so I maid a new list with the same products in the same sheet, trying to sort out rows with products which haven`t been given out. Thanks for reply