I have developed a dependent dropdown sheet. For example when user selects option in cell B2 then further options from C2:L2 are provided.
Now i interested that if any dropdown i.e. B2:E2 are changed than next cells should automatically clear content. I want to do this for all rows independently. I have written this code in VBA however since I have large amount of rows it is difficult
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
Range("C2:L2").ClearContents
End If
If Not Intersect(Target, Range("B3")) Is Nothing Then
Range("C3:L3").ClearContents
End If
End Sub
Kindly recommend an alternative solution to do it without too many lines.