would something like this work guys?
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "A3" Then If Target.Value = "Consolidated" Then Rows("15").EntireRow.Hidden = False If Target.Value <> "Consolidated" Then Rows("15").EntireRow.Hidden = True End If End Sub
Bookmarks