have two independent drop down list on one sheet with various macro attached to each drop down- the when pick from the second drop down list is does not work it intercepts zero- have tried to nest but does not work -is it possible to two independent dropdowns with different macro;s on one sheets
any help would be appreciated
thanks
Private Sub Worksheet_Change(ByVal Target As Range) 'Major customer and Internal Revenue
If Not Intersect(Target, Range("K1")) Is Nothing Then
Select Case Range("K1")
Case "Costco": Costco
Case "Overstock": Overstock
Case "Wayfair": Wayfair
Case "InternationalRev": InternationalRev
Case "Blank":
End Select
End If
End Sub
Private Sub Worksheet2_Change(ByVal Target As Range) 'All Internal and External Monthly Incentive
If Not Intersect(Target, Range("G1")) Is Nothing Then
Select Case Range("G1")
Case "InternalMoIncentive": InternalMoIncentive
Case "OutsideRepAdam": OutsideRepAdam
Case "MinorrepsP": MinorrepsP
Case ",OutsideRepSS_S": OutsideRepSS_S
Case "Blank":
End Select
End If
End Sub
Bookmarks