Compare and then merge 2 Excel documents

IN PROGRESS
Bids
47
Avg Bid (USD)
$42
Project Budget (USD)
$30 - $250

Project Description:
I need to compare 2 files containing products( JLS.csv & supplier.csv) , 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 supplier.csv
d) Update anything that is active or inactive on JLS going by the supplier.csv

Basically you are asking JLS.csv file- does this product code exist on supplier.csv(yes, no)? If no then add to JLS if yes then leave. Then asking JLS.csv, 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).

Skills required:
Excel
Hire martinstan
Project posted by:
martinstan United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 45
in 1 days
$ 50
in 0 days
$ 30
in 1 days
$ 30
in 1 days
Hire pyazlm
$ 30
in 2 days
Hire SergeyPlus
$ 30
in 1 days
Hire alexander2007
$ 30
in 1 days
$ 40
in 0 days
Hire nmppatel
$ 45
in 1 days
$ 30
in 0 days