Compare and then merge 2 Excel documents

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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

Excel

ID Проекту: #478770

Про проект

46 заявок(-ки) Дистанційний проект Остання активність Jul 30, 2009

Доручено:

agihcam

Please refer to PMB.

$30 USD за 1 день
(39 відгуків(-и))
5.1

46 фрілансерів(-и) готові виконати цю роботу у середньому за $42

svet63

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

$45 USD за 1 день
(57 відгуків(и))
6.5
Kamalkishover

Pls Check PM

$50 USD за 0 дні(-в)
(110 відгуків(и))
6.0
srinichal

I can dp the project

$30 USD за 1 день
(16 відгуків(и))
5.2
pyazlm

You better check PMB.

$30 USD за 2 дні(-в)
(30 відгуків(и))
4.4
$40 USD за 0 дні(-в)
(3 відгуків(и))
3.9
alexander2007

Please check PM. Thanks.

$30 USD за 1 день
(13 відгуків(и))
4.0
muhmuuh

Hello! Please check PM for details. Thanks

$30 USD за 1 день
(8 відгуків(и))
3.6
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 за 1 день
(9 відгуків(и))
3.7
himanshusofttech

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

$30 USD за 0 дні(-в)
(12 відгуків(и))
3.6
ranjitsinha

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

$30 USD за 1 день
(10 відгуків(и))
3.4
Weblogica

Ready to start working

$30 USD за 2 дні(-в)
(7 відгуків(и))
3.2
SoftSandila

can finish in one day. regards imran

$48 USD за 1 день
(4 відгуків(и))
3.3
monica365

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

$30 USD за 3 дні(-в)
(3 відгуків(и))
2.7
counterpuncher

For your consideration...

$30 USD за 5 дні(-в)
(3 відгуків(и))
2.9
refractocd

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

$30 USD за 1 день
(3 відгуків(и))
2.5
Abikris

Hi, See PMB for details. Kris

$30 USD за 1 день
(5 відгуків(и))
2.5
ropoint

I'm interesed to do your task. best regards

$30 USD за 1 день
(2 відгуків(и))
2.2
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 за 1 день
(2 відгуків(и))
2.4
azosilin

Please check PM

$30 USD за 1 день
(1 відгук)
2.0
riff79

It's a simple algorithm. Ready to work. Thanks

$30 USD за 1 день
(2 відгуків(и))
1.9