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.

Dovednosti: Zadávání dat, Excel

Zobrazit více: 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

O zaměstnavateli:
( 1 recenze ) Zurich, Switzerland

Identifikační číslo projektu: #12198491

Uděleno uživateli:


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 Další

€32 EUR za 2 dní
(53 recenzí)

29 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě €52


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 Další

€33 EUR za 1 den
(171 Recenzí)

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 Další

€70 EUR za 1 den
(137 Recenzí)

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 za 2 dní
(61 Recenzí)

A proposal has not yet been provided

€9 EUR za 1 den
(53 Recenzí)

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 za 1 den
(35 Recenzí)

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

€30 EUR za 1 den
(15 Recenzí)

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 Další

€111 EUR za 3 dní
(35 Recenzí)

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 Další

€24 EUR za 4 dní
(16 Recenzí)

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 Další

€30 EUR za 3 dní
(6 Recenzí)

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 Další

€10 EUR za 1 den
(7 Recenzí)
€111 EUR za 4 dní
(4 Recenzí)

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 Další

€19 EUR za 1 den
(2 Recenzí)
€23 EUR za 3 dní
(0 Recenzí)
€23 EUR za 1 den
(0 Recenzí)

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 Další

€14 EUR za 2 dní
(0 Recenzí)
€30 EUR za 2 dní
(0 Recenzí)

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 Další

€23 EUR za 1 den
(0 Recenzí)

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 Další

€12 EUR za 0 dní
(0 Recenzí)

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 za 1 den
(0 Recenzí)

Hello My Dear Client My name is Baran. I am an excel specialist. I am good at data analysis, serach and selections, combining and seperating tasks. I utllize VBA scripts. I am free to work for you Have a sh Další

€34 EUR za 1 den
(0 Recenzí)