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
ElseMsgBox "Ticket Already Exists."
Do Nothing
Any help would be great.