En cours

Combining excel sheets

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.

Compétences : Traitement de Données, Excel, Analyses statistiques

Voir plus : statistical algorithm, job spss, combining sheets excel, automotive quote sheets excel, updating costing sheets excel, easy sheets excel, sum multiple sheets excel, computer inventory sheets excel, excel combining delete duplicates

Concernant l'employeur :
( 5 commentaires ) Hanover, United States

N° du projet : #8533962

Décerné à :

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 Plus

250 $ USD en 3 jours
(134 Commentaires)
5.8
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 en 3 jours
(70 Commentaires)
5.1

52 freelance ont fait une offre moyenne de 406 $ pour ce travail

hossionsumon

Dear sir, Experts and top data entry service provider here ready to start work now .My success always measure with client's satisfaction. So, i always try to do the best. Please let me know if you have any questions. Plus

555 $ USD en 10 jours
(233 Commentaires)
7.0
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 Plus

250 $ USD en 2 jours
(160 Commentaires)
6.7
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 Plus

250 $ USD en 5 jours
(46 Commentaires)
6.4
wsh2

Summary: Highly experienced MsExcel programmer with excellent data integration knowledge and skills. Greetings from Easton PA.. {smile} Highly experienced (25+ years) MsExcel Business programming and database exp Plus

448 $ USD en 10 jours
(27 Commentaires)
5.7
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 Plus

500 $ USD en 3 jours
(72 Commentaires)
5.8
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 Plus

250 $ USD en 2 jours
(58 Commentaires)
5.4
rousseauassoc

I would be interested in speaking to you about you project as I feel I have the right experience and skill-set to help you achieve your goal. Specifically, I have a lot of experience in manipulating raw data into la Plus

578 $ USD en 5 jours
(10 Commentaires)
5.2
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 Plus

250 $ USD en 3 jours
(15 Commentaires)
5.5
tomislav1975

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

500 $ USD en 7 jours
(31 Commentaires)
5.0
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 Plus

250 $ USD en 10 jours
(50 Commentaires)
5.2
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 Plus

250 $ USD en 3 jours
(28 Commentaires)
5.0
Wasif966

we do in less then 250$

277 $ USD en 2 jours
(23 Commentaires)
4.6
zebracaro

i can do it for you quickly and exactly by vba

277 $ USD en 5 jours
(39 Commentaires)
4.4
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 Plus

277 $ USD en 4 jours
(18 Commentaires)
4.0
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 en 3 jours
(16 Commentaires)
3.6
aminbros

A proposal has not yet been provided

421 $ USD en 10 jours
(4 Commentaires)
3.6
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 Plus

555 $ USD en 3 jours
(6 Commentaires)
3.8
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 Plus

900 $ USD en 10 jours
(2 Commentaires)
3.3
lalmansari

-> Excellent Programmer -> 4+ years of experience in VBA programming, PDF designing and Excel Macro Development -> Will provide high quality product. -> I have a Master degree in Computer Application and kind of a w Plus

277 $ USD en 10 jours
(6 Commentaires)
3.2
Uber4U

Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation

277 $ USD en 6 jours
(4 Commentaires)
3.4