Excel: Automatically hiding and unhiding rows based on a cell value

I've researched most places on the internet for a solution and have been unsuccessful. I have VERY limited knowledge regarding macros but my spreadsheet requires automatic updates. I need to figure out how to have a given row hidden if column H of the same row is equal to "N". Any help is appreciated.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of June 10, 2014.

For more resources for Microsoft Excel