data validation
This is what i put in but nothing seems to be working, im not sure if i am supposed to change anything with the worksheet functio
Dim an
If WorksheetFunction.CountIf(Range("Tracking!C4:C1000 "), Range("Sale!P2")) 0 The
ans = MsgBox("Please Enter in Tracker", vbYesNo
If ans = vbYes Then SortTracke
End If
|