Finding Duplicates Across Multiple Workbooks.

Hi there, I wish to find duplicates from one worksheet to another which is located in a different workbook.

I will be using the "Deal-sheet" workbook as a reference to check against information located on a "client-sheet." All confirmed deals are located on the deal sheet.

I want to find whether or not the information found on the deal sheet can be matched against information located on the client sheet. If this is the case then I will need to delete the information on the client sheet. This will prevent any future communication between the two parties involved.

I have provided two workbooks to show an example. I wish to search for the company "Autoworld" or the contact name would be even better. This is located on the deal-sheet and on the client sheet. Find the row that is located on and either highlight this or delete. (Pref highlight)

In the future I will be searching for different companies using different workbooks.

Thanks in advance. If anyone can shed any light on how I would do this, It would be much appreciated.