Hiding Rows

[Rob32]

I have a list of 15 items (Say in column B1:B15)in column C1:C15 is a drop down box where the person can select either "Yes" or "No". if they select "yes" then the value of that item shows in the cell to its right (cells D1:D15). i have these cells linked to another tab where i have linked cells D1:D15 to say cells D30:D45 on the other Tab. Now what i want to know is if say cell C5 on the original tab = "No", can i somehow hide the whole Row to which that cell (say c5) relates to on the other tab, and then if i was to change the drop down box to "yes" again then that Whole row would then Unhide??

Thanks

ROB

 

[sam_d1]

Hi ROB,
Try the following code (in "Sub Worksheet_Change")
'>>> Code Start
Private Sub Worksheet_Change(ByVal Target As Range)
If UCase(Target.Value) = "NO" Then
Worksheets("Sheet2").Rows(Target.Row + 29).Hidden = True
ElseIf UCase(Target.Value) = "YES" Then
Worksheets("Sheet2").Rows(Target.Row + 29).Hidden = False
End If
End Sub

'>>> Code End

thanks
- sam