I was able to find code to create a default for a dependent drop down list on another thread:
http://www.excelforum.com/excel-prog...down-list.html
However, I have a dependent drop down list in more than one column and don't know how to add an Or statement or If statement properly to duplicate what is occuring in the target column. Below is my code:
If I also want to duplicate this in cells D11 & D17, F11 & F17, etc., how would I do that?![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Address = "$B$11" Then Application.EnableEvents = False Range("B17").Value = "<Select>" Application.EnableEvents = True End If End Sub
Bookmarks