Terminé

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.

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.

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

en voir plus : statistical algorithm, job spss, combining sheets excel, automotive quote sheets excel, updating costing sheets excel, vba code update sheets excel, easy sheets excel, sum multiple sheets excel, work sheets excel work book java, name sheets excel using vbscript, 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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(310 Commentaires)
0.0
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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(243 Commentaires)
0.0

51 freelance font une offre moyenne de $405 pour ce travail

saibababs

I am having hands of experience more than 18 years using computer tools like MS office and am capable complete the assignment within time line.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)
0.0
ExcelAustralia

Hi In response to your update: In my solution for this project you will need to do two things. 1) Enter the file path (paste from explorer) 2) Press a button The rest is automatic I an an Excel developer with Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
frankvigilante

I will provide you with the best solution for this project to ensure that you never have to worry about the laborious task of manually combining data again. If you select my bid, you will receive the following: 1. A Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(67 Commentaires)
0.0
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(100 Commentaires)
0.0
vw8136409vw

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(0 Commentaires)
0.0
Dillingham

Entry of data from numerous spreadsheets into one. Will deliver (due to amount of work) within 10 days. Will receive 1/2 payment upon award of project, the other 1/2 upon completion. Two redo after work is complete. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
mani0773

Chance to give more

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
anujkapoor1234

we have high experience in the excel

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
Nostrianemos

EXCEL FORMULA AND VBA MACRO EXPERT Highly experienced in developing excel user forms, VBA, pivot tables, power pivot, power query, and excel's data modeler. I have experienced 9 years in VBA macro excel. I am an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
SSVijayaPriya

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)
0.0
aminbros

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(23 Commentaires)
0.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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(566 Commentaires)
0.0
yellehemanth

Just send me the data & you will get the processed one in no time. My id is All data entry jobs can be sent to me & i have a team of people to do any such job in no time.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(11 Commentaires)
0.0
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(4 Commentaires)
0.0
Wasif966

we do in less then 250$

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(25 Commentaires)
0.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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(258 Commentaires)
0.0
tomislav1975

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(34 Commentaires)
0.0