Hide rows conditionally

[rkg]

Gurus,

I have 4 columns in a worksheet -each for a product-, with rows containing the sales figure of that particular product. I need to write 4 on-click macros for 4 buttons which will hide all rows where sales value of Product A (B or C or D) is empty. Since the products are in different columns, I cannot use a simple autofilter. Also, another button should unhide all rows of the sheet.

I would appreciate very much if someone would please guide me.

Thank you.