Đã hoàn thành

Combine data from 3 sheets into 1 excel sheet.

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem nhiều hơn: excel sheet marketing research survey data entry, data excel sheet macro, excel combine data, combine multiple excel sheets into one macro, merge multiple excel files into one sheet vba, combine multiple excel sheets into one sheet, combine multiple excel sheets into one sheet vba, how to consolidate data in excel from multiple workbooks, copy data from multiple worksheets into one, consolidate data from multiple worksheets in a single worksheet, how do you merge two excel spreadsheets together?, convert pdf data excel sheet, excel combine data sheets, macro place data multiple sheets entry excel, quick combine data sheets sheet excel, excel combine data different sheets, copy data web site table excel sheet vb code, data online mubasher pro excel sheet, service provider export data based website manages excel sheet records, purchase order sale data combine excel sheet

Về Bên Thuê:
( 6 nhận xét ) Wamberal, Australia

ID dự án: #18759834

Được trao cho:

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-Exce Thêm

$45 AUD trong 1 ngày
(28 Đánh Giá)
3.9

20 freelancer đang chào giá trung bình $106 cho công việc này

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 & Thêm

$150 AUD trong 2 ngày
(601 Nhận xét)
8.4
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 Thêm

$175 AUD trong 2 ngày
(359 Nhận xét)
8.3
SBITServices

Hello , I have checked the excel file, read your project description and understood your requirement. This is a simple task. I can write a simple macro to combine required from 3 excel sheets to one exce Thêm

$60 AUD trong 1 ngày
(454 Nhận xét)
7.5
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 pro Thêm

$50 AUD trong 1 ngày
(277 Nhận xét)
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 gr Thêm

$155 AUD trong 3 ngày
(75 Nhận xét)
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 trong 2 ngày
(124 Nhận xét)
6.4
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 Thêm

$60 AUD trong 2 ngày
(117 Nhận xét)
6.5
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 w Thêm

$155 AUD trong 3 ngày
(84 Nhận xét)
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 trong 4 ngày
(28 Nhận xét)
6.2
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 trong 3 ngày
(115 Nhận xét)
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 trong 3 ngày
(64 Nhận xét)
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 trong 3 ngày
(21 Nhận xét)
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 trong 1 ngày
(4 Nhận xét)
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 Thêm

$50 AUD trong 2 ngày
(11 Nhận xét)
3.2
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 Thêm

$155 AUD trong 3 ngày
(2 Nhận xét)
3.0
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 deta Thêm

$166 AUD trong 3 ngày
(13 Nhận xét)
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? Thêm

$60 AUD trong 3 ngày
(2 Nhận xét)
1.4
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 trong 1 ngày
(0 Nhận xét)
0.0
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 deliv Thêm

$72 AUD trong 2 ngày
(0 Nhận xét)
0.0