Find Jobs
Hire Freelancers

Consolidate several excel files in one

$30-250 USD

Completed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
Hello, we would like to have a function/macro/etc. to read all the excel spreadsheets inside one directory, and do the following: - Create a new excel spreadsheet with as many tabs as different tabs are in all the excels - Inside each tab, we need to create the first column with the name of the source spreadsheet and as many columns as different columns in the whole set (it should be the same structure in all but we can not guarantee 100%) and all data consolidated below Samples attached. The real set of spreadsheets are 40
Project ID: 5979560

About the project

15 proposals
Remote project
Active 10 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
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$66 USD in 0 day
4.9 (166 reviews)
6.5
6.5
15 freelancers are bidding on average $104 USD for this job
User Avatar
Hi there. I have seen the attached Excel files and I can write the VBA macro in one day that would process and copy all the sheet tabs in your required order. If you are interested, I can write the macro for you and you may pay me after checking is functionality. Regards. Usman.
$100 USD in 1 day
5.0 (72 reviews)
7.1
7.1
User Avatar
Hello, Greetings from Shweta, Bangalore India. I can provide you with a simple desktop application that can get this done for you. Will provide more details if you are interested. Cheers, Shweta
$100 USD in 1 day
4.9 (89 reviews)
6.0
6.0
User Avatar
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. However, please explain what is the source of column Ubicación in result sheet Almacenamiento (the values are Madrid)! In the source spreadsheets the appropriate values are Valgrande. In sheet Redes there are matching values (Cloud Datacenter01, Montes Sierra, etc.) Regards
$75 USD in 2 days
4.9 (62 reviews)
5.7
5.7
User Avatar
Hello, I checked your file and like to do this project. I have done many related projects and maybe do this project with cheap price, if I have more time to work on it.
$79 USD in 1 day
4.8 (75 reviews)
5.4
5.4
User Avatar
Hello, I have read your descriptions and examined the attached files, and I think I can do the work for you. The macro shall do exactly as you need , but first I need to know about the following: The sample Source 2 file contrains two sheetas as follows: "Base de Datos" and "Resumen" These two sheets contains multiple tables (or a single table, which does not start from Cell A1). What do you want the macro to do in such cases? Shall it ignore the second table, or any table that does not start from column A1? I have done several jobs like this in freelancer where the macro had to read several files from a single folder and manipulate data. So you can be sure that I'll deliver you a high quality job. With thanks & best regards Raad
$60 USD in 3 days
5.0 (32 reviews)
5.3
5.3
User Avatar
Hi, I am highly interested to your Data Entry project. I have the necessary qualification to attain your desire goal. I will follow your instruction exactly and will send you detailed report in excel sheet. So please check my profile and give me opportunity for demonstrate my career with your company. Thanks
$66 USD in 3 days
4.7 (2 reviews)
1.0
1.0
User Avatar
Hello Sir, Greetings..!! We are Octane Infosolution Pvt. Ltd. , a leading information technology services company, situated in Kolkata, India, delivering consulting and outsourcing solutions to clients across various industry verticals. We are a 15 member team equipped with a wide range of skill sets such as HTML/HTML5, CSS3, Wordpress, PHP, MYSQL, jQuery, AJAX, PayPal Integration, Paypal Adaptive Mode and Social networking. WE READ ALL YOUR REQUIREMENTS AND FOUND THAT THERE IS A MATCH WITH YOUR REQUIREMENTS AND OUR SKILL SET. Sir,Hence we are new in Freelancers,but I have got to tell you at this point of time that we have a very highly skilled team of programmers and designers who are well equipped to handle this project. So, you can expect to get the very best kind of service from us in the whole industry with a good turnaround time. That's a OIS's. guarantee . Some of our previous work specimens are as follows: As we have also some excellent guys for data procesing,so *we can do this Consolidate several excel files in one job* Some of our other PHP expertise areas are as follows: 1. HTML with responsive development. 2. PayPal Integration. 3. Facebook API. 4. Any Plugin customization. 5. HTTP to HTTPS conversion. 6. Google Maps API. 7. Video Integration. Kindly provide us a chance and we assure your time & money won't go to a waste. Looking forward to do business with you, Regards, OIS TEAM
$147 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am Mandar from India. Work with Tata Steel Ltd. as a Business Analyst. I am proficient in Microsoft Excel and do the same day in day out. Assure you the precise and timely delivery.
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
having six years of work ex in working with excel spreadsheets, believe in delivering quality jobs to customers. if u think i am suitable please feel free to contact.
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Concern I am a data entry operator and new freelancer. I can show you my full commitment towards your jobs. I enjoy working with people. I have experience in data entry, MS Office (Word, Excel ), typing,Windows desktop, emailing, web research, Gmail, and Facebook. I will apply my knowledge to projects and aim to please the client with the results. If I hired by you I will deliver my best work at a high standard. Thank You
$66 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have experience in working with microsoft excel, creating intelligent and self padding that will facilitate the work of your company spreadsheets. for further information, questions, or suggestions please contact. thank you, Ronniel
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SPAIN
Santiago de Compostela, Spain
5.0
276
Payment method verified
Member since Aug 6, 2003

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.