Hide Rows based on value in column

  • I've been searching the internet today and searched this forum for an answer with no luck. I'm really hoping someone here can help me out.

    I have a table in a spreadsheet where I am trying to hide any rows in the table which are populated with #N/A because their formula is resulting in that value. If I can just focus on rows specific to the table area in the sheet that will help. The rows which might need to be hidden are from 7 through 26, and they need to be hidden if the value in column H is #N/A. Is it possible to write a macro that will do this when I press a button on the sheet? I've attached a sample of part of my table.

    When the rows are hidden, the title row also needs to be hidden if the minor rows below it are all #N/A in column H. If there are multiple rows below the title such as the third section in the attached, with just one row #N/A in column H, only that individual row needs to be hidden. Hope I am making sense.

    Thank you!

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!