Thread: VB A to loop to search through a list and delete a record if found

I have two worksheets

Sheet1 column A has a list of ID numbers
Sheet2 Column L has that same ID number in it (somewhere)

I want to find each record from Sheet1 in Sheet2
If the record is found, I want to delete the entire ROW of that ID in Sheet 2
If it is not found, I want to continue looping through.

See attached workbook. Thanks!!

Feel free to post back an XLSM if you want. I really appreciate the help!

-Heather