Compare and then merge 2 Excel documents
$30-250 USD
Paid on delivery
I need to compare 2 files containing products( [url removed, login to view] & [url removed, login to view]) , 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 [url removed, login to view]
d) Update anything that is active or inactive on JLS going by the [url removed, login to view]
Basically you are asking [url removed, login to view] file- does this product code exist on [url removed, login to view](yes, no)? If no then add to JLS if yes then leave. Then asking [url removed, login to view], 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:
47 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