Standardize and Merge Excel Sheets

ปิด

คำอธิบาย

The project is basically about merging 206 excel files into one. Unfortunately, the layout of columns is not always the same. Therefore, they sometimes need to be standardized before (or after) merging.

In more detail:

I have excel files with FDI statistics for each country in the world, 206 files in total. In each file, there are 4 sheets: Inflows, Outflows, Instock and Outstock. In the end, I need to have only two sheets: one containing the merged information of all the inflow-sheets and one containing all the merged information of the instock-sheets.

As a template, I uploaded two original data files for Aruba and Afghanistan and two files with the merged data of these countries. Please refer to those examples for needed information, layout etc.

Important notes:

The column "FDI to" must be filled in manually. You find the country's name on top of each original sheet.

The country's names in column "FDI from" can be copied from the original tables. But you will sometimes have to delete empty cells in order to bring all the countries into one column.

Be careful: The order of the sheets in the original files is not always the same.

ทักษะ: คีย์ข้อมูล, Excel

ดูเพิ่มเติม: macro excel merge sheets, excel merge sheets, automotive quote sheets excel, vbscript excel merge, updating costing sheets excel, vba code update sheets excel, excel merge tab delimted, easy sheets excel, sum multiple sheets excel, work sheets excel work book java, excel merge data photoshop, name sheets excel using vbscript, excel project help needed, excel merge files mail duplicates, computer inventory sheets excel

หมายเลขโปรเจค: #12198491

มอบให้กับ:

KarnMukesh

Hi, I have reviewed the project description along with the attached .xlsx file and able to perform this task which require to merging 206 excel files into one according to the provided instruction. I make sure yo เพิ่มเติม

€32 EUR ใน 2 วัน
(19 บทวิจารณ์)
3.5

freelancer จำนวน 30 คน กำลังประมูลอยู่ที่ราคาเฉลี่ย €51 สำหรับงานนี้

Kalpanasekhar

Hello There, I can deliver my best service in fulfilling your requirement. Here I am a full-time excel, web research, web scraping, data entry, and email list building freelancer. I did check your requirements เพิ่มเติม

€33 EUR ใน 1 วัน
(124 บทวิจารณ์)
6.7
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 100 works on Freelancer where major เพิ่มเติม

€70 EUR ใน 1 วัน
(71 บทวิจารณ์)
5.8
macroPOL

Hello, I am Excel and VBA expert. I can start now. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

€55 EUR ใน 2 วัน
(51 บทวิจารณ์)
5.3
saranaone

I can complete your requirement on time with good quality results. I am open to work 30Hours/week on this. I am confident that i can deliver best service for you if i am awarded Thanks in advance!

€29 EUR ใน 1 วัน
(17 บทวิจารณ์)
5.0
rejaulkarim1

Hey there, Here is an excel expert from Bangladesh. I’ve already finish some big project here in freelancer.com with excellent feedback. I’ve seen your clear job description & eagerly wishing to be a part of your i เพิ่มเติม

€111 EUR ใน 3 วัน
(33 บทวิจารณ์)
4.5
The24CarrotsInc

A proposal has not yet been provided

€9 EUR ใน 1 วัน
(16 บทวิจารณ์)
3.9
AlexandrUKR

if the issue is actual please clarify next steps i can send first draft for your test within 4H since start เพิ่มเติม

€30 EUR ใน 1 วัน
(3 บทวิจารณ์)
3.5
accountantshetty

I am an accountant and a data entry expert with 15+ years of experience. I should be able to complete this task quickly and efficiently and withing the time frame. Please dropbox me the files and i will get crack เพิ่มเติม

€24 EUR ใน 4 วัน
(10 บทวิจารณ์)
3.1
laurajiannaras

Hello, I have more than ten years experience working full-time with Excel, including manipulation and formatting of data using manual data entry and, wherever feasible, automated (vba-macros) processes to accomplish เพิ่มเติม

€30 EUR ใน 3 วัน
(5 บทวิจารณ์)
3.3
Abdulk1986

With more than Eight years experience in Accounting, Finance, QuickBooks, Data Entry, Excel, Copy, Typing, Word, Power Point, Web Research, PDF Conversion, Translator, Proposal Writer. I can complete this project with เพิ่มเติม

€23 EUR ใน 1 วัน
(8 บทวิจารณ์)
2.5
Misujon3

Greetings! Hope you will not ignore my resume/cover letter or proposal letter whatever you mean it. Wish you could have spent some time to read this thoroughly. May be this will help you to get an eminent person or ma เพิ่มเติม

€10 EUR ใน 1 วัน
(3 บทวิจารณ์)
2.3
€111 EUR ใน 4 วัน
(2 บทวิจารณ์)
2.1
mahadevgis

Have very good experience in data entry, content writing, Advance excel sheet & WordPress etc.. Happy to work with you, and give you quality work.

€23 EUR ใน 1 วัน
(0 บทวิจารณ์)
0.0
thilina4me

I am Data Entry/Data Processing/excel Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are loo เพิ่มเติม

€8 EUR ใน 0 วัน
(0 บทวิจารณ์)
0.0
€23 EUR ใน 1 วัน
(0 บทวิจารณ์)
0.0
€30 EUR ใน 2 วัน
(0 บทวิจารณ์)
0.0
vishnuteja74

Dear Hiring Manager, I would like to apply in your job post. I think that I am the right person for the job. I am quite good at excel. I can apply formulas and get your task done quickly. I can complete the task เพิ่มเติม

€19 EUR ใน 1 วัน
(1 บทวิจารณ์)
0.0
harshgupta26

This can be achieved using excel macro which will read all the files and merge into one excel of your requirement. I have an experience of 9.5 yrs of experience in creating of excel macros which help users to reduce th เพิ่มเติม

€23 EUR ใน 1 วัน
(0 บทวิจารณ์)
0.0
viniciuscheim

Hi, I have strong experience in automate processes with excel sheets using a VBA programming, so unviable repetitive tasks, i can do quickly.

€23 EUR ใน 1 วัน
(0 บทวิจารณ์)
0.0
Swatijc02

Hello, I have understood your requirement for merging excel file and you need to have two sheets as Inflows and Instock, For this work, you have 206 files each with four sheets and the same task is to be done. เพิ่มเติม

€30 EUR ใน 3 วัน
(0 บทวิจารณ์)
0.0