₦airaland Forum

Im trying to compare two excel documents and if a value in one column of the first documents matches a column in the second document, data from that same row should be copied from the second document to the first. I tried a macro but it's not working properly

Are you trying to compare if there's duplicate or what?

Moreso, the 2 documents has to be together in a document, as in, Document A to be in sheet 1, while Document B to be in sheet 2

So you have to copy the document from the second excel to sheet 2 of the first document, then try again

cluewebhost:
Im trying to compare two excel documents and if a value in one column of the first documents matches a column in the second document, data from that same row should be copied from the second document to the first. I tried a macro but it's not working properly

Moreso, these 2 videos should help you:


https://www.youtube.com/watch?v=GdrOFBBEMQ8


https://www.youtube.com/watch?v=dcgX5YSHKvc


If you don't understand, kindly pm me, I am ready to help

okonja:
Moreso, these 2 videos should help you:


https://www.youtube.com/watch?v=GdrOFBBEMQ8


https://www.youtube.com/watch?v=dcgX5YSHKvc


If you don't understand, kindly pm me, I am ready to help

Thanks.

Emailed you.

cluewebhost:
Thanks.

Emailed you.

Sorry, I'm just coming online now...I read your mail, you will need to apply the Vlookup function. I will do a sample with your mail and send it back to you later

try www.post4solution.com a freelance job site that supports Naira transactions