Good Afternoon. I have a spreadsheet where I am tracking several entries in a table that will keep growing. Three fields are Data Validation Drop Down Lists. The macro below works well to clear the two lists to the right when the first one is changed by the user.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("E5:E9001")) Is Nothing Then
Range("F5").ClearContents
Range("G5").ClearContents
End If
End Sub
I am want this to affect the rows below it in the table as they are added.
Bookmarks