I have this workbook that has columns A through E with information. For column A, I was looking for a VBA that will compare the current data in the cell (starts at A2) until the end of data, to see if it matches with data in ("Sheet2") range would be G2 until the end of data. This will go through each row until the end of the data in ("Sheet1"). If it doesn't match with a value from ("Sheet2"), it will populate with the row location in ("Sheet1") where it doesn't match in a message box. It can either stop at the first instance of it not matching or it can have all instances in one MSGBOX either way works. Thank you in advance for the assistance.