Compare and then merge 2 Excel documents

This project was awarded to agihcam for $30 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

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).

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online