Search for value and exit macro if found

Good day, Gurus.

I have a macro that copies data from the active workbook to another workbook. If the data is already in the other workbook, however, I want to give a message, "This PO Number is Already in the Tracking Log", and then exit.

The value I want to search will always be found in cell M2 of the active workbook, and I really only need to search Column M of the other workbook to see if the value is found.

Here is what I have so far. The area with the extra line breaks is where I need to add the code to search and either give the message and exit or continue to run the macro:

Please Login or Register  to view this content.

Thanks in advance for any help you can offer.

Try

Please Login or Register  to view this content.