Hide and Unhide rows based on two values in two columns

[Satheesh9012]

Hi All

Please help i have values in column 8 and column 9, where in if column 8 issue type is selected with item1 column 9 will be visible and column 9 has three values in it so if column 9 (product) is selected with soap rows 21 should be visible, like vise there are three other values in column 9 as well for which rows should hide and unhide based on the selection, i have tried the below code so only column 8 works.

also note column 8 has 8 other values based on which rows are hidden and unhidden which is working fine for me.

please help when there is column 8 with issue type selected with item 1 column 9 unhides and column 9 has three other options where in the rows needs to be also hidden and unhidden


Private Sub Worksheet_Change(ByVal Target As Range)
If Range("Issue type").Value = "Item1" And Range("Product").Value = "Soap" Then
Rows(8).Hidden = False
Rows(21).Hidden = False
Rows(19).Hidden = False
Rows("9:18").Hidden = True
Rows(20).Hidden = True
If Range("Issue type").Value = "Item1" And Range("Product 2").Value = "Box" Then
Rows(8).Hidden = False
Rows(23).Hidden = False
Rows(19).Hidden = False
Rows("9:18").Hidden = True
Rows(20).Hidden = True
ElseIf Target.Value = "Item 2" Then
Rows(10).Hidden = False
Rows(16).Hidden = False
Rows(21).Hidden = False
Rows(9).Hidden = False
Rows(15).Hidden = False
Rows("11:14").Hidden = True
Rows("17:20").Hidden = True
'ElseIf Target.Value = "Item 3" Then
'Rows("9:21").Hidden = False
'Rows("19:20").Hidden = True
'Rows(8).Hidden = True
ElseIf Target.Value = "Item 4" Then
Rows("8:19").Hidden = True
Rows("20:21").Hidden = False
Rows(15).Hidden = False
ElseIf Target.Value = "Item 5" Then

End if
End Sub

 

[Fluff]

Duplicate to: Hide and Unhide rows based on two values in two columns

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.