Project Detail

Compare and then merge 2 Excel documents

Compare and then merge 2 Excel documents is project number 478770
posted at GetAFreelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: agihcam

Budget: $30-250

Created: 07/29/2009 at 17:02 EDT

Bid Count: 47

Average Bid:
$ 42

08/03/2009 at 17:02 EDT

Project Creator: martinstan
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (3 reviews)

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

Report Violation

Job Type

Excel

Messages Posted:2

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

07-29-2009 19:23 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(203 reviews)

alok007patel

0 days

07-29-2009 17:06 EDT

9.987/10
(77 reviews)

Ready to start now!Check your PMB please,Thanks!

adnansandhila

1 day

07-29-2009 19:12 EDT

9.9868/10
(76 reviews)

can finish in one day. regards imran

Kamalkishover

0 days

07-29-2009 17:35 EDT

9.9683/10
(63 reviews)

Pls Check PM

svet63

1 day

07-29-2009 20:03 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(40 reviews)

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

muhmuuh

1 day

07-30-2009 01:22 EDT

9.9722/10
(36 reviews)

Hello! Please check PM for details. Thanks

alexander2007

1 day

07-30-2009 00:02 EDT

9.7273/10
(33 reviews)

Please check PM. Thanks.

nmppatel

1 day

07-30-2009 03:38 EDT

9.6897/10
(29 reviews)

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.

srinichal

1 day

07-30-2009 06:10 EDT

9.7727/10
(22 reviews)

I can dp the project

pyazlm

2 days

07-29-2009 18:40 EDT

9.9375/10
(16 reviews)

You better check PMB.

SergeyPlus

1 day

07-29-2009 20:33 EDT

9.9375/10
(16 reviews)

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

agihcam

1 day

07-30-2009 10:08 EDT

9.8571/10
(14 reviews)

Please refer to PMB.

tindz99

2 days

07-29-2009 17:10 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(11 reviews)

please have a look at pm for details

tusharvv

1 day

07-29-2009 17:35 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(10 reviews)

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

azosilin

1 day

07-29-2009 19:19 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(9 reviews)

Please check PM

himanshusofttech

0 days

07-30-2009 09:29 EDT

9.7778/10
(9 reviews)

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

balajisriram

1 day

07-30-2009 02:08 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(8 reviews)

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

RainbowSearches

2 days

07-29-2009 19:40 EDT

9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10
(8 reviews)

Please see PM. Thanks.

monica365

3 days

07-30-2009 01:40 EDT

9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10
(5 reviews)

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

ropoint

1 day

07-29-2009 20:10 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(4 reviews)

I'm interesed to do your task. best regards

Weblogica

2 days

07-29-2009 17:21 EDT

9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10
(4 reviews)

Ready to start working

dataentry10on10

1 day

07-30-2009 01:10 EDT

9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10
(4 reviews)

We are interested..Thanks

ruby2406

0 days

07-30-2009 11:57 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(3 reviews)

Hi, nice to work with you. Please see PMB for more details. Thanhks you.

riff79

1 day

07-29-2009 22:02 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

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

Abikris

1 day

07-30-2009 01:52 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Hi, See PMB for details. Kris

counterpuncher

5 days

07-30-2009 01:55 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

For your consideration...

grabbala

0 days

07-30-2009 11:57 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Lets start the project. I am expert in VBA/Macros/excel. I will complete your project as much as faster with more than 100% Quality with in agreed time. Thanks, Bala. Quality Inc.

win4t4

1 day

07-30-2009 05:48 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Sounds easy, I can do this for you. I have many experience in processing data using excel since my main job is building custom Accounting Information System.

carlestops

3 days

07-30-2009 05:53 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Hello Sir/Madam I can do this. Please pm for sample about .txt and .csv samples I have done so far.

ranjitsinha

1 day

07-29-2009 17:08 EDT

(No Feedback Yet)

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

rajaJ

3 days

07-29-2009 17:14 EDT

(No Feedback Yet)

this project will be done within a week of time......

sreekanthreddyk

4 days

07-29-2009 17:20 EDT

(No Feedback Yet)

pls see the pm

sojibcu

1 day

07-29-2009 19:30 EDT

(No Feedback Yet)

Very efficient in data entry

aimanabbas

3 days

07-29-2009 17:33 EDT

(No Feedback Yet)

it wont take more than 3 days.. :)i am looking forward to see ur response :)

fig8

1 day

07-29-2009 19:23 EDT

(No Feedback Yet)

HAVE RICH EXPERIENCE IN DEVELOPPING ASAP. WILL SEND YOU THE DEMO BEFORE U MAKE DECISION

oxsalida

100

1 day

07-29-2009 19:28 EDT

(No Feedback Yet)

My estimate is most likely high, but I can complete the work immediately.

jubayerahmed

5 days

07-29-2009 19:44 EDT

(No Feedback Yet)

I have good experience on exel related all of event, so I thing it easy to me. I would like to post my proposal with 150 for total project only for 15 days.

adenikeju

2 days

07-29-2009 20:33 EDT

(No Feedback Yet)

I can deliver on this project in 2 days maximum, possibly even sooner. Thanks.

jhenvillamar

1 day

07-30-2009 01:16 EDT

(No Feedback Yet)

Hi there! I possess 3 years experience as encoder that pretty seems similar to what you are looking for. Also an expert SEO. I am a newbei, please give a chence to prove my skills. Sincerely, Jhen

sarfudheen

0 days

07-30-2009 02:51 EDT

(No Feedback Yet)

i can do your project. I have already done the same kind of project.

freelancejobz

1 day

07-30-2009 03:32 EDT

(No Feedback Yet)

I am expert in Excel.

sandyvgowda

100

1 day

07-30-2009 04:05 EDT

(No Feedback Yet)

Please see the PM

manickamK

0 days

07-30-2009 05:26 EDT

(No Feedback Yet)

Pls. Ref Our PM

workwell

1 day

07-30-2009 05:32 EDT

(No Feedback Yet)

I have a lot of experience with Excel. A simple VBA coding will sort this out. Let me have the project. Thanks.

surajitgh1976

250

2 days

07-30-2009 06:45 EDT

(No Feedback Yet)

need money for socal work.

asnanrifai

3 days

07-30-2009 08:37 EDT

(No Feedback Yet)

i have capability in excel function

helenalice

0 days

07-30-2009 11:23 EDT

(No Feedback Yet)

we can finish this ASAP.

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.