Hello everyone,

Tried a few different methods for this but nothing has worked so far as there is no "ID".

I have two different sets of customer data, in the same excel file and there are random bits of data missing for both of them.
The format for Sheet 1 lets say is:

TITLE FIRST NAME SURNAME Postcode ADD 1 ADD 2 ADD 3 ADD 4 ADD 5 COUNTY EMAIL TEL MOBILE
MR John BLANK LA1 555 65 havenlock warwick BLANK BLANK UK Derby johndoe@mail blank 08312937

and on sheet two it is:

FIRST NAME SURNAME email phone occupation address address_1 address_2 city county postcode
BLANK DOE johndoe@mail 9283183 blank 65 haven BLANK BLANK manchester derby BLANK

Some of the contacts will be duplicates and some will be new contacts. I want to merge the two files and where they are duplicates I want the missing information to get filled. Is there any formula or macro that would enable me to do this? The missing data will be random so there could be any field missing for each contact, meaning there is not really a common thing ("ID") or cell for both sets of data, and many people will have similar or the same surname but not actually be the same or a duplicate contact.

I'm sorry if this a bit unclear, I will try to further explain if anyone picks this up. There is around 10000 contacts on one sheet (the main sheet I want to keep) and 2000 more on the next one that I want to merge into the main sheet.