Standardize and Merge Excel Sheets

Ditutup

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

ID Proyek: #12198491

Diberikan kepada:

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 Lagi

€32 EUR dalam 2 hari
(19 Ulasan)
3.5

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

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 Lagi

€33 EUR dalam 1 hari
(124 Ulasan)
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 Lagi

€70 EUR dalam 1 hari
(71 Ulasan)
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 dalam 2 hari
(51 Ulasan)
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 dalam 1 hari
(17 Ulasan)
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 Lagi

€111 EUR dalam 3 hari
(33 Ulasan)
4.5
The24CarrotsInc

A proposal has not yet been provided

€9 EUR dalam 1 hari
(16 Ulasan)
3.9
AlexandrUKR

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

€30 EUR dalam 1 hari
(3 Ulasan)
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 Lagi

€24 EUR dalam 4 hari
(10 Ulasan)
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 Lagi

€30 EUR dalam 3 hari
(5 Ulasan)
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 Lagi

€23 EUR dalam 1 hari
(8 Ulasan)
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 Lagi

€10 EUR dalam 1 hari
(3 Ulasan)
2.3
€111 EUR dalam 4 hari
(2 Ulasan)
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 dalam 1 hari
(0 Ulasan)
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 Lagi

€8 EUR dalam 0 hari
(0 Ulasan)
0.0
€23 EUR dalam 1 hari
(0 Ulasan)
0.0
€30 EUR dalam 2 hari
(0 Ulasan)
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 Lagi

€19 EUR dalam 1 hari
(1 Ulasan)
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 Lagi

€23 EUR dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
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. Lagi

€30 EUR dalam 3 hari
(0 Ulasan)
0.0