Compare and then merge 2 Excel documents
$30-250 USD
Paid on delivery
I need to compare 2 files containing products( [login to view URL] & [login to view URL]) , then merge them:
a) Keeping the information that is the same on both (but JLS will have some columns already with data)
b) Remove any rows (going by product ID) on JLS that do not appear on the supplier.csv.
c) Add any rows (going by product ID) that do not appear on JLS but are on the [login to view URL]
d) Update anything that is active or inactive on JLS going by the [login to view URL]
Basically you are asking [login to view URL] file- does this product code exist on [login to view URL](yes, no)? If no then add to JLS if yes then leave. Then asking [login to view URL], do I have any product codes that are not on supplier.csv. (yes, no) if yes then remove from JLS. Then is this product active or inactive (on JLS).
Project ID: #478770
About the project
Awarded to:
46 freelancers are bidding on average $42 for this job
I am a VBA expert. I have very good experience with VBA Excel. I have completed many projects on GAF in this skill.I will provide quick & professional service.
Hi, I am ready to start your work and I understood it properly. I am looking farword from you. Thank you.
Hi, This can be easily done by employing VBA-Excel macros, within few hours (depending on the data volume). Thanks Balaji v4rU Global