Käynnissä

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

Taidot: Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 18 arvostelua ) Stevenage, United Kingdom

Projektin tunnus: #478770

Myönnetty käyttäjälle:

agihcam

Please refer to PMB.

30 $ USD 1 päivässä
(39 arvostelua)
5.1

47 freelanceria on tarjonnut keskimäärin 42 $ tähän työhön

svet63

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

45 $ USD 1 päivässä
(51 arvostelua)
6.3
Kamalkishover

Pls Check PM

50 $ USD 0 päivässä
(90 arvostelua)
5.8
srinichal

I can dp the project

30 $ USD 1 päivässä
(3 arvostelua)
4.4
pyazlm

You better check PMB.

30 $ USD 2 päivässä
(30 arvostelua)
4.4
SergeyPlus

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

30 $ USD 1 päivässä
(10 arvostelua)
4.0
alexander2007

Please check PM. Thanks.

30 $ USD 1 päivässä
(13 arvostelua)
4.0
40 $ USD 0 päivässä
(3 arvostelua)
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 1 päivässä
(9 arvostelua)
3.7
himanshusofttech

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

30 $ USD 0 päivässä
(12 arvostelua)
3.6
muhmuuh

Hello! Please check PM for details. Thanks

30 $ USD 1 päivässä
(8 arvostelua)
3.6
SoftSandila

can finish in one day. regards imran

48 $ USD 1 päivässä
(4 arvostelua)
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 1 päivässä
(10 arvostelua)
3.4
Weblogica

Ready to start working

30 $ USD 2 päivässä
(7 arvostelua)
3.3
counterpuncher

For your consideration...

30 $ USD 5 päivässä
(3 arvostelua)
2.9
monica365

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

30 $ USD 3 päivässä
(3 arvostelua)
2.7
Abikris

Hi, See PMB for details. Kris

30 $ USD 1 päivässä
(5 arvostelua)
2.5
refractocd

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

30 $ USD 1 päivässä
(3 arvostelua)
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 1 päivässä
(2 arvostelua)
2.4
ropoint

I'm interesed to do your task. best regards

30 $ USD 1 päivässä
(2 arvostelua)
2.2
azosilin

Please check PM

30 $ USD 1 päivässä
(1 arvostelu)
2.0