Copy a row, check table for duplicate, give option to overwrite duplicate before pasting

Hi
I have a workbook (MASTER) that copies a single row of information on contact names and addresses from other workbooks (Slave1, Slave2, etc) and pastes the information into a worksheet (ALL DATA) in MASTER.

Before pasting into MASTER, I want the process to check if the contact information is already in ALLDATA / MASTER. If it is, I need the option of overwriting the existing data, (there may be a change to address or some such), whatever row it's in, or paste the information into a new line if it's a new contact and doesn't cause a duplicate.

So far I've found a process that identifies a duplicate in a single cell in a column, but then asks for you to type in new information to overwrite the information to be pasted, rather than paste over the existing information.

Please Login or Register  to view this content.

I've attached a mock workbook in which I copy the list on sheet 2 into column A on sheet 1 to show the above code working, but now need to expand the code to identify the row the duplicate info is in and overwrite it with the info to be pasted, or paste the incoming info as a new line at the end of the list.

Thanks in advance!!

Frankie