Private Sub Worksheet_Change(ByVal Target As Range)
Dim K%
If Target.Address <> "$C$1" Then Exit Sub
Columns("D:K").AutoFit
For K = 4 To 11
If Cells(9, K) <> Target.Value Then Columns(K).ColumnWidth = 0
Next
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim K%
If Target.Address <> "$C$1" Then Exit Sub
Columns("D:K").AutoFit
For K = 4 To 11
If Cells(9, K) <> Target.Value Then Columns(K).ColumnWidth = 0
Next
End Sub