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.

Keahlian: Entri Data, Excel

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 1 ulasan ) Zurich, Switzerland

ID Proyek: #12198491

Diberikan kepada:


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 Lebih banyak

€32 EUR dalam 2 hari
(19 Ulasan)

30 freelancer menawar dengan rata-rata €51 untuk pekerjaan ini


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 Lebih banyak

€33 EUR dalam 1 hari
(124 Ulasan)

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 Lebih banyak

€70 EUR dalam 1 hari
(71 Ulasan)

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 dalam 2 hari
(51 Ulasan)

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 dalam 1 hari
(17 Ulasan)

Hey there, Here is an excel expert from Bangladesh. I’ve already finish some big project here in with excellent feedback. I’ve seen your clear job description & eagerly wishing to be a part of your i Lebih banyak

€111 EUR dalam 3 hari
(33 Ulasan)

A proposal has not yet been provided

€9 EUR dalam 1 hari
(16 Ulasan)

if the issue is actual please clarify next steps i can send first draft for your test within 4H since start Lebih banyak

€30 EUR dalam 1 hari
(3 Ulasan)

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 Lebih banyak

€24 EUR dalam 4 hari
(10 Ulasan)

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 Lebih banyak

€30 EUR dalam 3 hari
(5 Ulasan)

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 Lebih banyak

€23 EUR dalam 1 hari
(8 Ulasan)

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 Lebih banyak

€10 EUR dalam 1 hari
(3 Ulasan)
€111 EUR dalam 4 hari
(2 Ulasan)
€23 EUR dalam 3 hari
(0 Ulasan)

Hi! I am looking forward to helping you. Took the ECDL exam so I know how to perfectly use the Microsoft Office pack. We can talk about the price in order to find the best price for both of us. English level C2. You c Lebih banyak

€12 EUR dalam 0 hari
(0 Ulasan)

Sir... I am really interested to work on your project. And would be glad to talk about this project with [login to view URL] you want then mail me at this address:: miltonbiswasjohn At GmAiL DOT com. Best regard... Mahana Lebih banyak

€14 EUR dalam 2 hari
(0 Ulasan)
€30 EUR dalam 2 hari
(0 Ulasan)

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 Lebih banyak

€19 EUR dalam 1 hari
(1 Ulasan)

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 Lebih banyak

€23 EUR dalam 1 hari
(0 Ulasan)

I am very good at excel as i took many courses about excel in my university and school . Hire me and i promise i will never let you down . Thanks in advance .

€20 EUR dalam 1 hari
(0 Ulasan)
€23 EUR dalam 1 hari
(0 Ulasan)