Hi,
Ok so my problem is I have a number of dependent drop downs in one sheet. All on different columns
So for example D16 is dependent on the selection in D15. Then F16 is dependent on the selection in F15 and so on.
I have the below code which resets D16 if D15 is changed. But I need it to do the same for all columns individually.
So if I change F15 it resets F16 and so on.
Code:
If Target.Address = "$D$12" Then
Range("D13").Value = "Select From Drop Down"
End If
Thanks
Bookmarks