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.