Macro to show/hide rows based on data validation drop-down selection

[littlejilly]

good afternoon friends and happy memorial day for those of us stateside!

I am working to update a pricing calculator and would like to show/hide rows based on a number of 1 or more drop downs. For example, if cell D3 in the capture below is DiseaseExperience, then Row 9 (DiseaseExperience) should hide. Additionally, cells D:H of that same row should also clear from any prior selections.

There are a number of other intersecting conditions that might happen but I'm hoping is someone can start me on the code, I can adjust thereafter for the nested conditions. I'd very much like for the code to update on click.

Thanks!

 

[rpaulson]

right click on you sheet - view code.

paste this in.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("D6")) Is Nothing Then

    Rows("9:100").EntireRow.Hidden = False 'unhide all hidden rows
    For r = 9 To 100
        If Cells(r, "C") = Split([D6], "_")(0) Then
            Rows(r).EntireRow.Hidden = True
            Range("D" & r & ":H" & r).ClearContents
           End If
     Next r
End If

End Sub

let me know how it works.