Find Jobs
Hire Freelancers

Merge Data from two Excel Spreadsheets

$750-1500 USD

Closed
Posted over 4 years ago

$750-1500 USD

Paid on delivery
Have two files from various date ranges but contains data we would like to combine into a single spreadsheet. Via a Macro or VBA code. Column 1 contains Company names - total of about 9 columns about 350k-400 rows. Items will need to be inserted into the correct company and in the correct date order
Project ID: 22401308

About the project

73 proposals
Remote project
Active 4 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
73 freelancers are bidding on average $855 USD for this job
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will save relative data in corresponding columns. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $900* and can deliver within three days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 340 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$900 USD in 3 days
5.0 (684 reviews)
8.7
8.7
User Avatar
Hi, I have understand the project requirement & interested to make macro for this project. Please send a message so we can discuss more & start the project. Thanks.
$750 USD in 2 days
5.0 (470 reviews)
8.1
8.1
User Avatar
Is it possible to share both the file, We can do it with formula, We match data and get you clean non duplicate data after merging. Awaiting your response. thanks
$1,000 USD in 5 days
4.9 (411 reviews)
8.3
8.3
User Avatar
Dear Employer, I will write the VBA code for you which will combine the data from two files and will create one. Please message me and let me know on which criteria do you need to combine. I am an expert with over 12 years of experience with over 1000 projects delivered and will do a perfect job asap. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash
$750 USD in 2 days
5.0 (302 reviews)
8.4
8.4
User Avatar
Hello, I’m an Excel/VBA expert and I can merge your Excel files. Please check my profile and contact me to discuss further details. Regards.
$750 USD in 1 day
5.0 (516 reviews)
8.1
8.1
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write the macro as requested. Would be great if you can share your workbook for more context, kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further to consolidate and work on your project.
$1,000 USD in 20 days
5.0 (181 reviews)
7.7
7.7
User Avatar
Hi There, I have read your details & I think I am the perfect one for your job. I have completed several project like this. Quality & accuracy is my commitment. I am ready to show you free sample. Please message me back. Regard’s Razia Sultana
$1,000 USD in 7 days
5.0 (309 reviews)
7.5
7.5
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. I can process the data annually or via macro if necessary, depending on the structure of the data. Contact me to discuss the details. Best regards
$750 USD in 1 day
5.0 (346 reviews)
7.5
7.5
User Avatar
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
$1,125 USD in 7 days
4.9 (436 reviews)
7.6
7.6
User Avatar
Hi, I am confident that I can deliver quality and merge the two files into a single consolidated file. I intend to achieve this using VBA code. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$750 USD in 6 days
4.9 (220 reviews)
7.0
7.0
User Avatar
Hi, My expertise in using excel advanced formulas has helped me to successfully deliver several similar Projects across various freelancing platforms. I will utilize this skill set to merge the data from the two excel files, based on the two criteria which you have specified in the job description. Please revert with the two data sets and discuss at the earliest in order to finalize, so that I can deliver an accurate output with a quick turnaround. We can setup a Skype call to discuss the finer details, if required. Thanks, DC
$750 USD in 2 days
5.0 (32 reviews)
6.9
6.9
User Avatar
Hi, As per requirements I will merge the database as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed.I look forward to discussing the project with you and hopefully secure a long term working relationship. I am ready to work on this project now. Thanks and regards, Mohan
$750 USD in 5 days
5.0 (101 reviews)
6.5
6.5
User Avatar
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and I can start working on your project right away after a little discussion.
$750 USD in 1 day
4.9 (137 reviews)
6.4
6.4
User Avatar
Hi, I can develop excel vba (macro) to take 2 workbooks and combine them into one file according to required conditions. I am experienced Data Analyst and Macro Developer and have done many similar projects. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. So, can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$750 USD in 3 days
4.8 (156 reviews)
6.2
6.2
User Avatar
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : "Access Attendance", "Invoice & book-keeping management" and " Create sales and purchases database application" . Those 3 app-s will give you a view what/how I can code for your project via Ms Access. Besides, I can provide access to any my application. I can code all based on your instructions via Ms Excel or via MS Access- professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
$750 USD in 5 days
4.7 (51 reviews)
6.2
6.2
User Avatar
Hello there, I am interested in the project. I can do the job through VBA script or Excel automation. Could you please provide some sample data for review? Thank You.
$850 USD in 7 days
4.8 (40 reviews)
5.7
5.7
User Avatar
I am experienced at data processing based on VBA coding. I have been conducting similar projects based on different input data from various sources (Sheets, CSV files, flat files with predefined structure etc). The target workbook may be based on multiple sheets or even multiple workbooks.
$750 USD in 7 days
5.0 (9 reviews)
5.6
5.6
User Avatar
I can do the job! Because of file size, I might need to process with Python. I would need to know the matching criteria. Are you interested in resulting sheet or do you need the macro/program? About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$750 USD in 5 days
5.0 (51 reviews)
5.5
5.5
User Avatar
Hi, let me see some entries on data file I'll get an idea. I have huge background of fixing up unsorted data to the desired state. Just pass some entries to me and the brief instructions of what exactly you wanted to do with this. I look forward to speaking with you! Thank you!
$750 USD in 7 days
5.0 (17 reviews)
5.1
5.1
User Avatar
Hi, I can create a VBA or macro to do this. If you send me a sample file with some rows of representative data, I can give a better estimate on time and cost. Regards. Reuben
$750 USD in 7 days
5.0 (26 reviews)
5.2
5.2

About the client

Flag of UNITED STATES
Miami, United States
0.0
0
Member since Nov 18, 2019

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.