Find Jobs
Hire Freelancers

Combining excel sheets

$250-750 USD

Completed
Posted over 8 years ago

$250-750 USD

Paid on delivery
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.
Project ID: 8533962

About the project

48 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 your job right now :) Thank You Sincerely Prameswara :)
$250 USD in 3 days
4.9 (426 reviews)
7.6
7.6
User Avatar
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 in 3 days
5.0 (258 reviews)
6.6
6.6
48 freelancers are bidding on average $407 USD for this job
User Avatar
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 niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$250 USD in 2 days
5.0 (886 reviews)
9.3
9.3
User Avatar
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 appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$250 USD in 10 days
4.9 (384 reviews)
8.0
8.0
User Avatar
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 you need it can be achieved. But such details should be spoken personally. Best regards
$500 USD in 3 days
5.0 (334 reviews)
7.5
7.5
User Avatar
i can do it for you quickly and exactly by vba
$277 USD in 5 days
4.9 (123 reviews)
7.1
7.1
User Avatar
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 can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$250 USD in 3 days
4.7 (60 reviews)
7.1
7.1
User Avatar
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 excel files (xls or xlsx), and it will process the files and output the Combined file in xls or xlsx format, which will be similar to your example. You can choose to run the said script on a local PC using WAMP or on a good PHP host that is live. We we can discuss the functionality in detail. I will provide support/fixes if any issues arise. I am extremely detail oriented and I strive for quality in my work. I have excellent previous record of completing projects with great client feedback. Looking forward to seeing your reply. Thanks. Regards Ahsan
$250 USD in 5 days
4.9 (76 reviews)
6.7
6.7
User Avatar
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 in 3 days
4.8 (102 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
$421 USD in 10 days
5.0 (40 reviews)
6.3
6.3
User Avatar
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 know if you are interested. Hello, I went through your updated description. As said, if the macro is developed to support one sheet, then it is pretty simple to make it generalize across all sheets. I think the macro is what it matters. Give me a ping, so that I can share you my idea on this. Thanks
$250 USD in 2 days
5.0 (117 reviews)
6.1
6.1
User Avatar
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 different tests. The tool I uses are SPSS, EXCEL, minitab, Weka and R for programming. Thank you for considering my proposal 
$300 USD in 4 days
4.9 (31 reviews)
5.4
5.4
User Avatar
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 entire data analysis life cycle from requirements through listing, questionnaire design, field strategy, data gathering, cleaning, analysis and reporting. Moreover, I assisted economists and public policy experts based at HARVARD UNIVERSITY, PRINCETON UNIVERSITY, LONDON SCHOOL OF ECONOMICS AND LAHORE UNIVERSITY OF MANAGEMENT SCIENCES. I have the experience, confidence, demeanor and desire to be in position where I can manage development solutions. I speak well in public and have strong technical writing skills. In addition, I am willing and able to take on leadership roles. I have a thorough understanding of econometrics, statistics and finance how the Regression and economic analysis could be used to interoperate the data meaningfully. Able to work on own initiative and as part of a team. First-class analytical, design and problem solving skills. Well-versed in current and new finance methodologies. 1. Strong knowledge and experience of complete data analysis life cycle. 2. Highly skilled in statistical software’s like Stata, Excel and SPSS 3. Proven ability to determine priorities, schedule work and meet critical deadlines. 4. Proven ability to manage a team and use of scarce resources efficiently.
$900 USD in 10 days
5.0 (26 reviews)
5.5
5.5
User Avatar
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 in 3 days
4.7 (67 reviews)
5.7
5.7
User Avatar
HI, please see my profile, contact me if you find me suitable for work. With regards, Tomislav____________________________________________________
$500 USD in 7 days
4.9 (34 reviews)
5.3
5.3
User Avatar
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 number of files. Ready to start work immediately
$277 USD in 4 days
4.6 (67 reviews)
5.4
5.4
User Avatar
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 to process 25 files one by one. Generally in these kind of cases we use SAS to read the data and then merge. SAS gives flexibility in manipulation as well. I have looked into your datasets. What we would like to know is if all the data sets have similar format or not? If not that should not be a problem. Kindly let us know if you want to discuss this further with us. We can give you the best quality output with assured after sales service if required. Also you would get the lowest price. Kindly let us know. Regards, Pal
$250 USD in 3 days
4.8 (36 reviews)
5.3
5.3
User Avatar
we do in less then 250$
$277 USD in 2 days
4.6 (25 reviews)
4.7
4.7
User Avatar
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 ready to start.
$555 USD in 3 days
4.7 (14 reviews)
4.3
4.3
User Avatar
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 : -. Macro to compile source data to master data -. Macro to load source file directly from pre-selected folder, all file selected in-sequence will load automatically, no human dependent to select file & load one by one. Thanks & Regards, gsanggara
$300 USD in 10 days
4.9 (27 reviews)
4.3
4.3
User Avatar
Hi, it should be easy for me. But I need more explanation on the example file Thanks................................................................................................................................................................
$250 USD in 5 days
4.6 (12 reviews)
4.0
4.0
User Avatar
A proposal has not yet been provided
$777 USD in 10 days
5.0 (6 reviews)
3.5
3.5

About the client

Flag of UNITED STATES
Hanover, United States
5.0
5
Payment method verified
Member since Jul 12, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.