Emoncada
08-31-2015, 06:34 AM
I have Sheet1 and Sheet2.
I would like to have the Column A in sheet1 as the target. So after the user enters data in that column it would search for that value in Sheet2
It would search for that value in Sheet2 Column A also. I
f it finds a match it would let the user know
MsgBox "Ticket Already Exists."
Else
Do Nothing
Any help would be great.
I would like to have the Column A in sheet1 as the target. So after the user enters data in that column it would search for that value in Sheet2
It would search for that value in Sheet2 Column A also. I
f it finds a match it would let the user know
MsgBox "Ticket Already Exists."
Else
Do Nothing
Any help would be great.