I have created a macro that sorts the data with both csv files (attached) based on column A and then copying the columns from one to the other file, but this give me incorrect information because of data comes from 2 different sources and the formating seems to be different. I just need to combine the missing fields from the two files.

I could not upload the csv files so I renamed them as .txt

Thanks.

Attachment 175538Attachment 175539