Experts:
I asked a previous question. Was answered completely... this is a followup. You may want to refer to below, and the solution.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28008108.html
Additional question:
I would now like to have the data in columns g thru k also move when the dropdown item list changes.
Please see attached Excel file for example of what I need. Please see code behind the "data" tab for what is working currently... Code was very kindly provided by
ssaqibh!
thanks in advance.
Rick D Norris
DropDownExample---New.xls
Dim cel As Range
Dim scel As Range
Dim dv
Dim dvn() As String
Dim nf As Boolean
Dim tmp As Variant
If Target.Count = 1 And Not Intersect(Target, Range("G1:K1")) Is Nothing Then
For Each cel In Range("G1:K1")
If cel.Address <> Target.Address Then
If cel = Target Then
dvn = Split(Replace(ThisWorkbook
For Each dv In Sheets(dvn(0)).Range(dvn(1
nf = False
For Each scel In Range("G1:K1")
If scel = dv Then nf = True: Exit For
Next scel
If Not nf Then
cel = dv
tmp = Target.Offset(1).Resize(Ta
Target.Offset(1).Resize(Ta
cel.Offset(1).Resize(cel.E
Exit Sub
End If
Next dv
End If
End If
Next cel
End If
End Sub