In Progress

Compare and then merge 2 Excel documents

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

Skills: Excel

See more: merge compare excel documents, csv codes, excel compare merge, merge excel files, merge data, do excel, data merge, amp excel, compare exist, csv merge, excel amp, data compare, compare rows excel, excel compare update, compare update, excel compare columns data, update csv file products, excel data update, excel data csv, codes csv, compare documents, file excel compare, codes excel, update excel, product information excel

About the Employer:
( 18 reviews ) Stevenage, United Kingdom

Project ID: #478770

Awarded to:

agihcam

Please refer to PMB.

$30 USD in 1 day
(39 Reviews)
5.1

47 freelancers are bidding on average $42 for this job

svet63

Excel/VBA developer since 1997. Can do. Regards, Svet.

$45 USD in 1 day
(51 Reviews)
6.3
Kamalkishover

Pls Check PM

$50 USD in 0 days
(90 Reviews)
5.8
srinichal

I can dp the project

$30 USD in 1 day
(3 Reviews)
4.4
pyazlm

You better check PMB.

$30 USD in 2 days
(30 Reviews)
4.4
SergeyPlus

Hello. I can do it in two hours. Sergey S.

$30 USD in 1 day
(10 Reviews)
4.0
alexander2007

Please check PM. Thanks.

$30 USD in 1 day
(13 Reviews)
4.0
$40 USD in 0 days
(3 Reviews)
4.0
nmppatel

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.

$45 USD in 1 day
(9 Reviews)
3.7
himanshusofttech

Hi, We are ready to work on your project. Thanks, Himanshu Softtech

$30 USD in 0 days
(12 Reviews)
3.6
muhmuuh

Hello! Please check PM for details. Thanks

$30 USD in 1 day
(8 Reviews)
3.6
SoftSandila

can finish in one day. regards imran

$48 USD in 1 day
(4 Reviews)
3.5
ranjitsinha

Hi, I am ready to start your work and I understood it properly. I am looking farword from you. Thank you.

$30 USD in 1 day
(10 Reviews)
3.4
Weblogica

Ready to start working

$30 USD in 2 days
(7 Reviews)
3.3
counterpuncher

For your consideration...

$30 USD in 5 days
(3 Reviews)
2.9
monica365

Hi, I have experience working with Ms Excel spreadsheets. Thanks! Monica

$30 USD in 3 days
(3 Reviews)
2.7
Abikris

Hi, See PMB for details. Kris

$30 USD in 1 day
(5 Reviews)
2.5
refractocd

Ready to start immediately. This can be done using Excel VBA. Please refer to PMB

$30 USD in 1 day
(3 Reviews)
2.5
balajisriram

Hi, This can be easily done by employing VBA-Excel macros, within few hours (depending on the data volume). Thanks Balaji v4rU Global

$30 USD in 1 day
(2 Reviews)
2.4
ropoint

I'm interesed to do your task. best regards

$30 USD in 1 day
(2 Reviews)
2.2
azosilin

Please check PM

$30 USD in 1 day
(1 Review)
2.0