Very new to this so. Is there any way to have the option cell K473 be on tab 1 and change the hidden rows on tabs 2 to 11? The below works perfectly on a single sheet, but would like to have the same result on several sheets, based on the choice on the first sheet.
Thanks in advance, John
Private Sub Worksheet_Change(ByVal Target As Range)
Dim iCell As Range: Set iCell = Intersect(Range("k473"), Target)
If iCell Is Nothing Then Exit Sub
If iCell.Value = "Quoted_Rates" Then
Rows("481:492").Hidden = False
Rows("474:480").Hidden = True
ElseIf iCell.Value = "Cost_Rate" Then
Rows("481:492").Hidden = True
Rows("474:480").Hidden = False
'Else ' do nothing
End If
End Sub