Find Jobs
Hire Freelancers

Merge Data from two Excel Spreadsheets

$750-1500 USD

Zaprt
Objavljeno pred več kot 4 leti

$750-1500 USD

Plačilo ob dostavi
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
ID projekta: 22401308

Več o projektu

73 ponudb
Projekt na daljavo
Aktivno pred 4 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
73 freelancerjev je oddalo ponudbo s povprečno vrednostjo $855 USD za to delo
Avatar uporabnika
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 v 3 dneh
5,0 (684 ocen)
8,7
8,7
Avatar uporabnika
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 v 2 dneh
5,0 (470 ocen)
8,1
8,1
Avatar uporabnika
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 v 5 dneh
4,9 (411 ocen)
8,3
8,3
Avatar uporabnika
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 v 2 dneh
5,0 (302 ocen)
8,4
8,4
Avatar uporabnika
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 v 1 dnevu
5,0 (516 ocen)
8,1
8,1
Avatar uporabnika
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 v 20 dneh
5,0 (181 ocen)
7,7
7,7
Avatar uporabnika
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 v 7 dneh
5,0 (309 ocen)
7,5
7,5
Avatar uporabnika
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 v 1 dnevu
5,0 (346 ocen)
7,5
7,5
Avatar uporabnika
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 v 7 dneh
4,9 (436 ocen)
7,6
7,6
Avatar uporabnika
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 v 6 dneh
4,9 (220 ocen)
7,0
7,0
Avatar uporabnika
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 v 2 dneh
5,0 (32 ocen)
6,9
6,9
Avatar uporabnika
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 v 5 dneh
5,0 (101 ocen)
6,5
6,5
Avatar uporabnika
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 v 1 dnevu
4,9 (137 ocen)
6,4
6,4
Avatar uporabnika
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 v 3 dneh
4,8 (156 ocen)
6,2
6,2
Avatar uporabnika
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 v 5 dneh
4,7 (51 ocen)
6,2
6,2
Avatar uporabnika
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 v 7 dneh
4,8 (40 ocen)
5,7
5,7
Avatar uporabnika
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 v 7 dneh
5,0 (9 ocen)
5,6
5,6
Avatar uporabnika
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 v 5 dneh
5,0 (51 ocen)
5,5
5,5
Avatar uporabnika
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 v 7 dneh
5,0 (17 ocen)
5,1
5,1
Avatar uporabnika
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 v 7 dneh
5,0 (26 ocen)
5,2
5,2

O stranki

Zastava UNITED STATES
Miami, United States
0,0
0
Član(ica) od nov. 18, 2019

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.