Combining excel sheets

Ukończone Opublikowano Sep 22, 2015 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

I need to combine a bunch of excel files into one master excel file. Your job would be to use any statistical program (ideally either just excel or stata or spss) to combine the data in the excel file sheets into one master combined excel file.

I am attaching a sample file called Combined... This file is a sample of the original excel file.

I am attaching the master file, with the subheadings, and two rows example.

Sub =Subject

Slideshow is SS1 named on the file.

All of the processes will have to be automated.

Your job would be to write an algorithm to do this.

We only have 5 files so far, but anticipate 20 files total over the next year.

Therefore, would like an automated process rather than someone manually doing it.

So I have received many proposals.
However, I need to emphasize again that I need the code and I need everything automated, with very minimal manual labor.
to confirm that you can do this, if possible, please do this for a few sheets on the one excel file I provided, and put it in the master file.
I just want to make sure the format is correct, and you understood everything.

Przetwarzanie danych Excel Analiza Statystyczna

Numer ID Projektu: #8533962

O projekcie

48 ofert Zdalny projekt Aktywny Sep 25, 2015

Przyznany użytkownikowi:

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel via VBA macro, include make combine sheet like you want Sir :) please give me a chance for doing your job and im able to start doing yo Więcej

$250 USD w ciągu 3 dni
(426 ocen)
7.6
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$250 USD w ciągu 3 dni
(258 ocen)
6.6

48 freelancerów złożyło ofertę za $407 w tym projekcie

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Więcej

$250 USD w ciągu 2 dni
(886 Oceny)
9.3
mirniyazuddin92

Dear Sir/Ma'am, Price and duration will vary depending on actual project. I am a Web research and Data Entry expert. I checked and understood your requirements. I can handle this job very well to your apprec Więcej

$250 USD w ciągu 10 dni
(384 Oceny)
8.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. PS: What yo Więcej

$500 USD w ciągu 3 dni
(334 Oceny)
7.5
zebracaro

i can do it for you quickly and exactly by vba

$277 USD w ciągu 5 dni
(123 Oceny)
7.1
fabest

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you c Więcej

$250 USD w ciągu 3 dni
(60 Oceny)
7.1
Beacon09

Hi I have carefully checked attached spreadsheets, and read and understood the details. I can create a custom PHP script (preferred) or a Windows application to automate this task. You will be able to upload the exc Więcej

$250 USD w ciągu 5 dni
(76 Oceny)
6.7
citijayamala

expert in excel. I can combine multiple spreadsheet to a single spreadsheet .good in vlookup concepts macros pivot tables charts and all excel functions

$277 USD w ciągu 3 dni
(102 Oceny)
6.5
aminbros

A proposal has not yet been provided

$421 USD w ciągu 10 dni
(40 Oceny)
6.3
gokulanand

Hello I understand your complete requirement. I can guarantee to get you a automated processing of files ( even in future ) via an excel macro. I am sure I can complete the task in the next 24 to 48 hours. Let me kn Więcej

$250 USD w ciągu 2 dni
(117 Oceny)
6.1
Softeria

I am a STATISTICS tutor for last 5 years. I have expertise in Statistical Analysis. I can show you some of my previous analysis. I have excellent concepts of Random variables, Probability Distribution, Sampling and di Więcej

$300 USD w ciągu 4 dni
(31 Oceny)
5.4
Hassanmurtza

I can automate it 90-95% through using STATA I have a strong and proven track record of doing data analysis, Statistical Analysis, Survey Analysis and forecasting future outcomes in financial markets. I have worked Więcej

$900 USD w ciągu 10 dni
(26 Oceny)
5.5
HajjiO

Hello, obviously you need a generalized macro excel useful for this task and for the future ones i 'm able to provide it to you

$277 USD w ciągu 3 dni
(67 Oceny)
5.7
tomislav1975

HI, please see my profile, contact me if you find me suitable for work. With regards, Tomislav____________________________________________________

$500 USD w ciągu 7 dni
(34 Oceny)
5.3
surekash7096

I have the expertise in Excel and can create a script to automate the process - either dynamically where it gives you the option of file selection or automatically, if you are sure about the naming convention and numbe Więcej

$277 USD w ciągu 4 dni
(67 Oceny)
5.4
d2imatrix

Hi, We would do it in $200. We are experts in quantitative analytics, data processing and automation. The file merging task can be done using excel VBA macro. We can do that. However this would take higher run time Więcej

$250 USD w ciągu 3 dni
(36 Oceny)
5.3
Wasif966

we do in less then 250$

$277 USD w ciągu 2 dni
(25 Oceny)
4.7
Calleus

Hi, I have strong background in Research, Reporting, Statistics, quantitative and qualitative analysis and experience in SPSS. Let me help you. Daily writes scientific papers, and I'm used to technical language. I am r Więcej

$555 USD w ciągu 3 dni
(14 Oceny)
4.3
gsanggara

Hi.. I interested to your project & place bid for your consideration. I am available right now. if you award the project to me, i will start to do it immediately. looking forward to hearing from you. Proposal Więcej

$300 USD w ciągu 10 dni
(27 Oceny)
4.3
jnekam

Hi, it should be easy for me. But I need more explanation on the example file Thanks.................................................................................................................................. Więcej

$250 USD w ciągu 5 dni
(12 Oceny)
4.0
itachi23

A proposal has not yet been provided

$777 USD w ciągu 10 dni
(6 Oceny)
3.5