Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,150,723 members, 7,809,750 topics. Date: Friday, 26 April 2024 at 02:14 PM

Who Knows Excel Macros/vba - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Who Knows Excel Macros/vba (1246 Views)

Excel VBA Forum Needed / VBA Programmers, Lets Connect For Freelance Opportunities. / Please Someone Should Help Vba To Compute The Product And Sum Of H.C.F And L.C.M (2) (3) (4)

(1) (Reply) (Go Down)

Who Knows Excel Macros/vba by cluewebhost(m): 10:09am On Mar 28, 2018
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
Re: Who Knows Excel Macros/vba by okonja(m): 10:14am On Mar 28, 2018
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
Re: Who Knows Excel Macros/vba by okonja(m): 10:37am On Mar 28, 2018
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
Re: Who Knows Excel Macros/vba by cluewebhost(m): 4:42pm On Mar 28, 2018
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.
Re: Who Knows Excel Macros/vba by okonja(m): 8:50pm On Mar 28, 2018
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
Re: Who Knows Excel Macros/vba by Gamelord007: 10:51pm On Mar 31, 2018
try www.post4solution.com a freelance job site that supports Naira transactions

(1) (Reply)

Deinstalling Oracle 11g / Very Urgent, / ...

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.