Auto-hide/show Rows based on Yes/No Criteria

Try this. It will automatically run each time you change a yes or no value

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("C:C")) Is Nothing Then
    If Target.Offset(, 2).Value <> "N/A" And Len(Target.Offset(, 2).Value) <> 0 Then
        Application.EnableEvents = False
        Dim vSplit As Variant:  vSplit = Split(Target.Offset(, 2).Value, "-")
        Select Case Target
            Case Is = "Yes"
                Rows(vSplit(0) & ":" & vSplit(1)).Hidden = False
            Case Is = "No"
                Rows(vSplit(0) & ":" & vSplit(1)).Hidden = True
        End Select
        Application.EnableEvents = True
    End If
End If

End Sub

Originally Posted by jakeruby

Thanks for the response - where does it designate which specific Rows are hidden?

If you are talking to stnkynts, he very cleverly used the values you put into column E.

Originally Posted by jakeruby

Thanks for the response - where does it designate which specific Rows are hidden?

As skywriter observed it utilizes the rows that you describe in column E. This way, in the future, you can quickly change the rows and the macro will hide/show your new indicated rows. Let me know if you have any other questions.