Find Jobs
Hire Freelancers

Write VBA for Combining Multiple Spreadsheets with Multiple Sheets

£20-250 GBP

In Progress
Posted over 7 years ago

£20-250 GBP

Paid on delivery
I am using a software programme call Primavera P6, this allows me to export information from the software into Excel. Each project is generated as it's own spreadsheet with up to five tabs within each spreadsheet. As these are always in the same format, then there is no need to match columns with different columns between spreadsheets. These spreadsheets are all saved to the same directory. One problems to overcome is that the first two rows of each spreadsheet and tab contains header information. I only need the first row and the second row can be deleted. I am looking for some VBA to be written that can compile all of the separate spreadsheets and tabs into a single combined spreadsheet with the same tabs. Have the same column information from the first row of the first spreadsheet and the remaining spreadsheets have the first two rows deleted. I have provided an example of a single spreadsheet. Instructions should be provided on how I change the VBA to look at different directories.
Project ID: 11878681

About the project

11 proposals
Remote project
Active 7 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
11 freelancers are bidding on average £108 GBP 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 0 failed projects and 100% 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 sample work before you consider awarding me the project. Thanks, Jay
£100 GBP in 2 days
5.0 (563 reviews)
8.2
8.2
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
£70 GBP in 0 day
4.9 (236 reviews)
7.4
7.4
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do make vba script to combining multiple spreadsheet with multiple sheets Sir :) please give me a chance for doing your job and im able to start doing your project right now Thank You Sincerley Prameswara
£23 GBP in 3 days
4.9 (315 reviews)
7.0
7.0
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
£126 GBP in 3 days
4.8 (256 reviews)
7.1
7.1
User Avatar
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
£88 GBP in 3 days
5.0 (67 reviews)
6.0
6.0
User Avatar
Good morning, I am working with Excel for a long time and I can create complex formulas and macros. For your project I will create a macro that will look into a folder (you could easily select which one) and open all files in it. Then a new file fill be created (or records will be added to existing one) that will have all lines from all files and tabs (excluding header) added to the master file. If you are interested please open a chat with me. Kind regards, Sorin
£50 GBP in 3 days
5.0 (36 reviews)
4.8
4.8
User Avatar
Hello, I would like to offer cooperation on this project. I am very reliable and efficient. The project will be deliver asap.
£150 GBP in 3 days
5.0 (6 reviews)
2.6
2.6

About the client

Flag of UNITED KINGDOM
Shoreham-by-Sea, United Kingdom
5.0
2
Payment method verified
Member since May 31, 2016

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.