Find Jobs
Hire Freelancers

Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and then create a csv output

£20-250 GBP

Cancelled
Posted almost 6 years ago

£20-250 GBP

Paid on delivery
Requirement: Create a spreadsheet where we can combine 2 separate spreadsheets together, manipulate the data and then create a function to export to a csv file in a certain format. This piece of work brings data together from 2 sources which we will download ourselves on a daily basis: Sheet 1 (AH Data) Sheet 2 (PF Data) Stage 1: Importing all data and merging 2 sheets Create a sheet which has 2 buttons which will allow us to import the 2 above spreadsheets from local files on a PC. Sheet 1 has data on several tabs (could be 50 or more) this all needs to be consolidated on to one sheet. A VLOOKUP will be required to add 4 columns of data from Sheet 2 onto the relevant record in sheet 1. This will give us a full data set for the day. Stage 2: Data Manipulation Once we have all the data on one sheet it needs to be manipulated. We need to create certain rules which will rule out some of the lines of data. There will be 2 main rules that need to be applied. We believe these will be IF functions. We then need to remove duplicates. This process will then give us the data set we require. Stage 3: CSV export We would then like a button which would export certain columns of this manipulated/filtered data into a CSV file. Other Information: This sheet is to be used on a daily basis. It will be the same data sources but different data each day but the same filters would be applied. The actual detail of the work required and example sheets 1 & 2 will be given once the bid is awarded.
Project ID: 16987725

About the project

45 proposals
Remote project
Active 6 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
Hi Sir I have checked the complete details of the project and will create a macro to import 2 sheets with multiple [login to view URL] Them together. Perform data analysis and macro to export the result as CSV Regards
£90 GBP in 3 days
5.0 (369 reviews)
6.6
6.6
45 freelancers are bidding on average £134 GBP for this job
User Avatar
Hi, I have worked with such large csv/excel sheets and manipulating them and producing a result sheet. Then we can export it to CSV. First if all I needed to see a sample sheet from you. I can do this as an excel add in project . Then only I can tell the feasibility THanks
£277 GBP in 5 days
4.9 (533 reviews)
8.4
8.4
User Avatar
Hello Sir, Thank you for this opportunity. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I 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 in advance, please pay me once the job is 100% complete. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
£150 GBP in 3 days
5.0 (640 reviews)
8.3
8.3
User Avatar
Hi there..... Warm Greetings We came along with your request for Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and then create a csv output and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Entry, Data Processing, Excel, Software Architecture, Visual Basic We have worked on 330+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
£150 GBP in 3 days
4.9 (306 reviews)
7.7
7.7
User Avatar
Hi, I am an Excel macro expert and have prior experience in handling similar projects involving merging of Excel data and filtering. Shall provide an user friendly interface to select the input files and save output in desired csv format. Let me know. Regards, Arul
£250 GBP in 3 days
5.0 (253 reviews)
7.4
7.4
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please send me a message so that we can discuss more.
£100 GBP in 3 days
4.9 (282 reviews)
7.2
7.2
User Avatar
Hello Sir, I am interested in this project. I can provide you a more customized solution for this excel project. Please let me know if you would like to discuss. Thanks Aanvik
£150 GBP in 3 days
5.0 (56 reviews)
6.7
6.7
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
£100 GBP in 2 days
5.0 (216 reviews)
6.8
6.8
User Avatar
Hi, there. My name's Paris Pallas and I'm an Excel expert. Having completed almost 230 projects during the last 5 years successfully I feel really confident in assisting with yours as well. You're welcome to visit my portfolio and get an idea of my work quality and professionalism. I've read your brief and I can implement all steps mentioned there. I'm going to need a couple of days to deliver a draft version. Please, let me know if you're going to need my services so that I can arrange my schedule accordingly. Thank you in advance! Paris
£120 GBP in 3 days
4.9 (169 reviews)
6.9
6.9
User Avatar
Hi, I have experience of working on similar data automation projects. Please let me know if you are interested and I am available to discuss and start right away.
£150 GBP in 3 days
4.7 (72 reviews)
7.2
7.2
User Avatar
Hello. I have a great experience with excel, VBA, export to csv. I had similar tasks as you can see in reviews in my profile. I have a 100% completed tasks. I'll make the best solution for you. Could you send me actual detail and example?
£149 GBP in 3 days
5.0 (58 reviews)
6.1
6.1
User Avatar
I have excellent command on MS Excel and can do the merging and exporting of data as specified. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile
£150 GBP in 3 days
4.9 (87 reviews)
5.9
5.9
User Avatar
Hi, I have read very carefully your project details about creating a spreadsheet to combine two different spreadsheets together, manipulating data and creating a function to export to a csv file. I am absolutely sure that I can complete this project professionally. Rather than just show you past similar projects, I want to exceed your expectation by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. Please let my reviews do the talking. Do you want me to start working on the sample right away?
£150 GBP in 3 days
4.7 (33 reviews)
5.5
5.5
User Avatar
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do the best job in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Please, message me and let us discuss more about your project. Thanks
£70 GBP in 3 days
4.9 (71 reviews)
5.3
5.3
User Avatar
!!!Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss.................................. Cheers :(
£166 GBP in 2 days
4.9 (45 reviews)
5.3
5.3
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
£122 GBP in 3 days
4.9 (66 reviews)
5.5
5.5
User Avatar
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yelp,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details .Thank you :)
£55 GBP in 3 days
5.0 (63 reviews)
5.1
5.1
User Avatar
I have the experience and expertise in Excel to combine files and create csv files based on your given criteria. Ready to start work immediately.
£100 GBP in 2 days
4.6 (71 reviews)
5.2
5.2
User Avatar
Suggest this be done with a tool built into an Excel file (after all, you already have the software). The tool would grab the files (perhaps with default file names (or patterns depending on the date etc.), perform the wizardry, then generate the output. [Perhaps saving the Excel result for later review or other uses.] This could be run directly, or perhaps set up as a scheduled task on Windows. Thanks for taking the time to consider my bid. David
£40 GBP in 2 days
5.0 (22 reviews)
4.1
4.1
User Avatar
Hi there, Your project interested me & I believe I can complete it as you required. I have completed several projects successfully. I assure you 100% completion. Contact me for more details. Payment and Duration is negotiable. Looking forward to work with you. Thank you.
£100 GBP in 5 days
5.0 (10 reviews)
4.1
4.1
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
£83 GBP in 3 days
4.9 (29 reviews)
4.3
4.3

About the client

Flag of UNITED KINGDOM
Crawley, United Kingdom
5.0
2
Payment method verified
Member since Feb 13, 2017

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.