How to hide rows based on data in certain columns

[timschaeffer]

Hello,

I am looking to hide rows depending on the the data in certain rows. If any column (C-G) have < 1, then I would like to hide that row. Or only show rows that have a value of > 0 in columns C-G. Same thing I'm guessing.

Attached sheet has the data on the second tab and the desired output on a first tab.

Thanks,

Tim

[Pete_UK]

You can't use a formula to hide a row - you would need a macro to do that.

Pete