Combine data from 3 sheets into 1 excel sheet.

$30-250 AUD

Imekamilika

Imechapishwa

about 5 years ago

$30-250 AUD

Kulipwa wakati wa kufikishwa

Hi, I have a main data sheet on excel. I need 6 columns of data from a second sheet to move and match relevant data on the first sheet (there is a common link with name/address but some with a slight variance). I also need 7 columns of data on the third sheet to move and match relevant data on the first sheet (again there is a common link with a name but some with a slight variance). There is about 3000 rows of data, though all follow the same pattern! Attached is the first 60 or so rows as an example. (On the main sheet I need rows S-X filled with data from F-K on the second sheet. The Service name and address is the common link) I also need rows Z-AF filled with data from rows B-H on the third sheet - the Provider name is the common link). Thanking you for your consideration. Please only bid if you have read the brief and are able to help with this.

Data Entry

Data Processing

Excel

Kitambulisho cha mradi: 18759834

Kuhusu mradi

20 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@Ahmed818

Hello i can write simple VBA script to combing the 3 sheets based on the criteria you are asking for i can finish in few hours samples of my VBA work : https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ waiting your answer on chat Thank you

$45 AUD ndani ya siku 1

4.9

(28 hakiki)

3.9

20 wafanyakazi huru wana zabuni kwa wastani $106 AUD kwa kazi hii

@Innovative116

Hi there. I am a spreadsheet formatting expert. I checked attached spreadsheet. Merging data from sheet 2 and 3 into master spreadsheet will be done within 2 days of project awarding. I have years of experience merging/formatting spreadsheets. Please check my feed backs for my expertise. I can start now. Looking for more discussion via chat. Best, Harish

$175 AUD ndani ya siku 2

4.9

(359 hakiki)

8.3

@Joshua777

Hi there, I have excellent experience in Excel, I have understood your project. I will Combine Excel sheets as per your requirement. I can confirm you that I will be able to complete your project with 100% quality & accuracy. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here http://www.freelancer.com/u/Joshua777.html I can start the work immediately. Kindly reply, Thank you.

$150 AUD ndani ya siku 2

4.9

(601 hakiki)

8.4

@eltamarisa85

Dear PAULK1, I can start now to move and match relevant data from a second and third sheet to first sheet. I don't have any work for this time, so i can spend all my time. I have completed some data processing project before, feel free to review my profile. Please give me the chance, i'm serious to work fast and accurate. Hopefully I can offer you my service and contribute to your success. Regards Nurul H

$50 AUD ndani ya siku 1

4.9

(277 hakiki)

6.9

@polarjin2017

Hello? How are you? I have seen the project - "Combine data from 3 sheets into 1 excel sheet.." As you can see my profile in these fields((Data Entry, Data Processing, Excel)), I have been working for 7 yrs as a great assistant for the clients. When I work in the project, I prefer to work by asking and answering each other for the project status. So that, i always try my best to deliver great result without any issue. I will get paid once you have satisfied the result. If I did not deliver good result on time, I will not get paid. Therefore, I wanna work with you if you do not mind. Hope to work with you. Thank you.

$155 AUD ndani ya siku 3

4.9

(75 hakiki)

6.5

@faheems189

Hello There, I have read project details briefly and I can perform work as you explained about all 3 sheets of data, I will combine all 3 sheets into one as per explained details, I can complete this work in 2 days for $60 AUD. Kindly message me for further discuss and sample files to get work started ASAP. Awaiting for your positive response, With best regards, Faheem S.

$60 AUD ndani ya siku 2

4.9

(117 hakiki)

6.5

@Erimmoni

sir job is clear I have see excel fie so please contact me I can complete full task in tomorrow same time.thanks..................................

$100 AUD ndani ya siku 2

5.0

(124 hakiki)

6.4

@asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$100 AUD ndani ya siku 3

5.0

(115 hakiki)

6.2

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Sure, it involves manual+automation to complete this job. Will do it with care. Willing to take up your project. Thank you, Regards.

$155 AUD ndani ya siku 3

4.9

(84 hakiki)

6.0

@hdlan

Hello, I can match and move 3,000 rows of data on the main sheet. I’m available now. Best regards, Duong

$200 AUD ndani ya siku 4

4.8

(28 hakiki)

6.2

@rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$50 AUD ndani ya siku 3

5.0

(64 hakiki)

5.5

@sevillajk01

hello! let me do it for you. Just share to me the spreadsheet and I will take care of the rest. I offer high quality and accurate output. Hope you will consider me, thanks.

$100 AUD ndani ya siku 3

5.0

(21 hakiki)

4.3

@mrherkar

Hi there, I could develop an Excel application to do this merge so 100% accuracy is guaranteed. You'd receive an Excel file, I do everything Any good? Cheers

$49 AUD ndani ya siku 1

5.0

(4 hakiki)

3.5

@khanconsultancy

Hi i am interested in your project give me chance to do send me message i will give you sample work done i have no other work now so i can fulfill your requirements as soon as possible i can start work now i can also work as per your conditions THank you

$50 AUD ndani ya siku 2

5.0

(11 hakiki)

3.2

@radinrahman09

<< 100% money back gurantee, if you are not satisfied>> Dear Hiring Manager, Good Morning. Have a Good day! This is Mir Touhidur Rahman. It is my pleasure to be able to bid on your project.I have read your job details on Data Entry & Internet Research. According to your job description you need a fast worker for your Data Entry & Internet Research Project. I am fully expert in - Data Entry, Research, Internet Research, Web Research, Extracting Email, Email Handling, Data Mining, MS Office(Full), Google, Bing, Yahoo, Google Docs, Google Document, Google Spreadsheet, Lead Generation, Directory and other Administrative Support related jobs. I can assure you that I will be able to submit your task in time with quality work. I have already completed so many projects. Please have a look on my portfolio and profile. I have listed many successful projects in my work history area. Lastly, I want to say you that, don't ignore me for thinking that, I am new freelancer, Just give me a chance, to prove me, - "I am not special, Just limited edition". I am a quick, reliable and efficient worker. I am available to start work immediately. I am waiting to be hired in this project to show my skills. Regards Mir Touhidur Rahman

$166 AUD ndani ya siku 3

5.0

(13 hakiki)

3.0

@Neno585

Hello, as a SQL expert, I can import all your data to SQL and do all required data processing within SQL Server Management studio and export the data in your desired format back to excel. Feel free to contact me if you would like to share more details about the project. Thank you for your consideration. Cheers!

$155 AUD ndani ya siku 3

4.8

(2 hakiki)

3.0

@JSHastie

Hey there, I could definitely help with this. Are you looking for cell formulas to achieve this? Or you're not picky about how it get's done? What about the variances? Just spelling and spacing differences? Regards Jerrad.

$60 AUD ndani ya siku 3

5.0

(2 hakiki)

1.4

@kaimenyijohn5

Hello, am glad I have found your task. I have been a freelance writer for more than 5 years and guarantee well-researched work full of content matched with timely delivery. I guarantee that if you hire me, I will deliver professional work that meets your specifications. Kindly get back to me so that we can discuss further concerning the task. I am also ready to attach a Turnitin report if required. Am looking forward to hearing from you. Thanks.

$72 AUD ndani ya siku 2

0.0

(0 hakiki)

0.0

@ianjames412

Hi there, I am very interested in this task. I checked the excel, I think using Microsoft database could make it easier instead of matching one by one. Hope we can talk about it in advance. thanks.

$166 AUD ndani ya siku 1