Find Jobs
Hire Freelancers

Create programme or macro to combine multiple excel sheets into one

$30-250 AUD

Completed
Posted almost 10 years ago

$30-250 AUD

Paid on delivery
Hi Freelancers, I require either a excel macro or a executable to combine the data from unto 6 different databases. The individual databases are all stored in an excel spread sheet. Each database contains the same columns, there are approximately ten columns in each. There can be many rows of data (up to 30,000) in each individual database. I will provide examples of each database to the awarded freelancer. The individual databases are all contained within the same folder. Once the databases have been combined into a single database, the database should be checked for duplicates and these duplicates removed. The database then needs to be converted to a CSV file. After conversion the database needs to be uploaded to a server using FTP. The macro/programme will be run automatically using windows scheduler. I know all of this can be achieved using an excel macro, however if you are more comfortable writing an .exe that is fine. If a .exe is used there will need to be a way to point the programme to the source of the individual databases as more databases may be added in the future. Thanks.
Project ID: 5780499

About the project

37 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
I can write you an .exe that does what you want. My bid includes the program's source code and 2 years of free support & debugging. Can you please send me a little sample of a database like the ones you'll be joining? Thanks, Razvan
$100 AUD in 2 days
5.0 (63 reviews)
6.1
6.1
37 freelancers are bidding on average $128 AUD for this job
User Avatar
Hello - I am an Expert Techno-Functional Analyst 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 the niche bidder who has 0 failed projects because I work till the fullest satisfaction of employers and you can find the same in any of the past reviews of mine. 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 before awarding me. Thanks, Jay P.S. - I have bid an average of the budget range you posted but can be flexible as per efforts involved.
$100 AUD in 4 days
5.0 (692 reviews)
8.4
8.4
User Avatar
Hi, I'll be happy to write the macro to combine all databases and then remove duplicates. The rest is not very clear and can be easily done manually Please feel free to message me if you need to discuss
$110 AUD in 3 days
4.9 (260 reviews)
7.7
7.7
User Avatar
Hi, I am an Excel macro specialist would would be happy to take on your project. Shall deliver an Excel macro meeting your requirement within two days. Let me know the Excel version in use and provide sample data. Thanks, Arul
$100 AUD in 3 days
5.0 (208 reviews)
7.4
7.4
User Avatar
HI Quadrellis. I would be glad to write an Excel macro for you that would do the desired job. I am currently engaged in a very similar project. From which database format do you intend to export ? Kindly discuss. Regards. Usman.
$160 AUD in 3 days
5.0 (97 reviews)
7.2
7.2
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$200 AUD in 10 days
4.8 (134 reviews)
6.4
6.4
User Avatar
Hi, i can develop an exe for your job. As i have done number of automated applications so i am aware what type of issues come in such applications and you will have an exe which will free from those. For example: Biggest issue in such applications which run 24/7 is the memory issue. Also exe will allow you to set the ftp information dynamically. Keenly looking forward your response.
$100 AUD in 2 days
4.9 (36 reviews)
5.7
5.7
User Avatar
Hi, I can make exe in Visual Basic 6 , with dialog you can mufti select your excel files, after processing you select output file and that is that. Also source code provided if you need later independent update. Regards, Misa
$90 AUD in 3 days
4.9 (27 reviews)
5.3
5.3
User Avatar
Hi there, If selected, I will create an exe file using Visual Studio. For data importing I will use OleDb approach. In this way I will develop an application that will allow you to import large files. Furthermore, if ok with you, I will remove the duplicates at the import time. This way the application will work faster. Wishing you the best, Ionut Rosca
$155 AUD in 5 days
5.0 (13 reviews)
5.1
5.1
User Avatar
I have 8 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start Can You send me your Sample file or Project details ? if you want i will also send demo of my work or you can download from my profile also (VB6.0 + Access Database) waiting for your feedback on same.
$200 AUD in 3 days
5.0 (28 reviews)
5.2
5.2
User Avatar
hi, im expert in excel and desktop aplication development, i have done several excel macros.. i can do this job well, thanks, tristan
$30 AUD in 3 days
4.9 (33 reviews)
4.8
4.8
User Avatar
Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for project files. During our contract I will be available via Skype/Gtalk, email and via site message center. All of these messages are forwarded to my cell phone so you can rest assured communication will not be a problem. Bugs fixing and minor changes are included in the bid without any additional fees. Best regards, Adrian
$100 AUD in 3 days
4.9 (19 reviews)
4.8
4.8
User Avatar
Hello sir, i can develop an executable application using C# or VB.NET or VBA to combine the excel sheets and create CSV files where needed. Best Regards vnb400
$155 AUD in 3 days
4.8 (50 reviews)
5.0
5.0
User Avatar
As you have mentioned in your description, the entire task can be automated and completed using a single Excel macro. I can provide the final deliverable within 10 hours. if you wish to see my sample works i can email them to you.
$45 AUD in 1 day
4.8 (24 reviews)
4.6
4.6
User Avatar
Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in Excel Macro. I can provide you the best cheap prices the best results. If you had interest for my suggestion, please call me. I await for you. Best Regards.
$30 AUD in 3 days
5.0 (7 reviews)
4.5
4.5
User Avatar
i am expert in Excel macro I read through the job details extremely carefully and understand you’re required, for this I am absolutely sure that I can do the project very well. I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I ll complete your project with 100% accuracy. Pls review my feedback. i have enough time to do ur project.... i am ready to start ur project..... Reviews from Past Employers (more reviews-http://www.freelancer.com/u/yes0.html) zkNovus - USA “ There are always difficulties in every project, but Yes0 handled everything professionally and quickly. He delivered the product as expected, on time and in perfect quality. ” ballywho1 - USA “ Absolute Best Data Extractor on Freelancer he rocks! Delivered on time and with great success I am so happy! ” SmartSourcing - USA “ Completed the data scraping project as requested, quickly and with constant communication through the entire process. Thank you! ”
$40 AUD in 0 day
5.0 (61 reviews)
4.3
4.3
User Avatar
This is a simple macro in VBA Excel. I can do it right now and finish this job in two-three hours. Also, I will do it at minimun price. If you are interested, please send me a message. Thanks!
$30 AUD in 0 day
4.8 (17 reviews)
4.1
4.1
User Avatar
Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. Thanks, Murtaza
$250 AUD in 3 days
5.0 (8 reviews)
4.1
4.1
User Avatar
Hi, I work exclusively on Excel VBA projects. I have gone through your requirements and I am confident that the required functionality can be provided using Excel VBA macros. Please provide me with further details so that I can send you the approach and get it vetted by you before starting to work on the project Looking forward for your reply Thanks & Regards Excel Solutin
$111 AUD in 3 days
4.7 (18 reviews)
4.2
4.2
User Avatar
Hi, What kind of databases are those? is it SQL database or oracle? I am an individual freelance, having more than 10yrs of exp in developing applications, window & web based, using .Net (C#.Net, Asp.Net (MVC), XML, WPF, WCF (Webservices) kendo ui, MySQL and SQL Server etc). By worked with Giants clients like Microsoft as a vendor, got expertise in delivering the quality code with in the time please see my profile. Time and cost may vary based on the complexity and the requirements. Awaiting for your positive response
$150 AUD in 1 day
4.8 (14 reviews)
3.9
3.9
User Avatar
Hello Sir, I can do this job by creating a package of Business intelligence tool, This package will be doing everything. Best Regards Kallol
$111 AUD in 2 days
5.0 (2 reviews)
3.6
3.6

About the client

Flag of AUSTRALIA
Elemore Vale, Australia
5.0
14
Payment method verified
Member since Jan 26, 2014

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.