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

In Progress
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: 17225165

About the project

39 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
Hello, I'm a full-time VBA developer. I have experience in manipulating Excel and text data, for example mentioned CSV. My macros don't use formulas, as formulas are much slower, especially for big data sets. I am proficient in complex calculations and data structure modification. Things like last row with data are naturally automatically detected. I will do button for CSV export and will gladly provide suggestions to make everything convenient for user once I'm familiar with the file. Best Regards
£105 GBP in 3 days
5.0 (64 reviews)
5.3
5.3
39 freelancers are bidding on average £133 GBP for this job
User Avatar
HI, I am good at excel and vba programming. I have referred the provided description briefly. Please share the files to review the data and looking forward to have discussion to understand more about the problem. I can transfer the data from spreadsheet, summarize and create csv files. -Chandra
£150 GBP in 3 days
5.0 (1186 reviews)
8.4
8.4
User Avatar
Hello, I can help with you in your project Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and then create a .csv output. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Software Architecture, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
£150 GBP in 3 days
4.9 (589 reviews)
8.5
8.5
User Avatar
Dear Client, We are interested in your project and ready to go for it. We have read your job description carefully and understood the project. We have done similar projects so confident to handle this project. You can check our profile and reviews and hope you would consider us for your project. We look forward to hearing from you. Kind Regards, Safeer Ali Eagles Inc.
£200 GBP in 4 days
5.0 (222 reviews)
8.4
8.4
User Avatar
I am an experienced Data Analyst with advanced skills in Excel and Power BI. I am used to deal with large amount of data. I can deliver your project in excel or Power BI. Just give me the opportunity to show you what i can do. Thanks!
£183 GBP in 3 days
4.9 (73 reviews)
6.9
6.9
User Avatar
Hi, I am an Excel expert. I can create an Excel template to merge files and save to .CSV file with great care and accuracy. Regards Soni
£100 GBP in 3 days
5.0 (213 reviews)
6.6
6.6
User Avatar
I am a professional with a decade of experience working in a US based NASDAQ registered company's finance department with a pro level Excel Skills,
£33 GBP in 3 days
4.9 (138 reviews)
6.5
6.5
User Avatar
Hi, I am expert in excel, vba and power bi. I can combine all your excel and other source data using excel power query and can create data model for data processing in excel power pivot. Please sent me source data with clear specifications I will complete for free and will send you the result. After checking my work if you were happy with my work then you can award me. Thanks
£100 GBP in 3 days
4.9 (108 reviews)
6.3
6.3
User Avatar
i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
£122 GBP in 3 days
4.9 (38 reviews)
5.9
5.9
User Avatar
Hello, I would love to help you with this project. It sounds like something I could do for you, because I am proficient with Excel and VBA. I have a lot of experience with similar work. Please contact me for more information.
£74 GBP in 1 day
5.0 (158 reviews)
5.9
5.9
User Avatar
Hello Sir, Rady to Combine data for you. Read all the details., I can easily do this great job for you. Let's start. Thanks
£150 GBP in 3 days
4.8 (69 reviews)
5.8
5.8
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. I am a full-time freelancer, I can start working on the project immediately. Regards
£88 GBP in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
HI I am an excel-vba Expert and I can finish your project so fast start the chat to discuss more about project an even cost I am ready to start now ...........................................................................
£111 GBP in 3 days
5.0 (39 reviews)
5.4
5.4
User Avatar
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
£55 GBP in 1 day
4.9 (54 reviews)
5.5
5.5
User Avatar
how are you,sir? I am a professional developer who has rich experience in this field. If you contact me, you and i will all be happy. Thank you for your reply in advance. Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and then create a .csv output Data Entry, Data Processing, Excel, Software Architecture, Visual Basic,
£150 GBP in 1 day
4.8 (13 reviews)
4.6
4.6
User Avatar
I'm confident to assist you with my experience in similar projects. If you award this project to me, I'll do my maximum to complete the work as per your requirements accurately / timely.
£40 GBP in 2 days
4.9 (16 reviews)
3.9
3.9
User Avatar
I am an excel specialist. I will achieve your goal by using macros. Macros employ visual basic programming language to add additional functionalities and customizations to excel spreadsheets. The spreadsheets will be combined and manipulated using custom functions. The end result will then be saved as a csv file with any name you want. I will also provide the vb source code. This will be done in 2 days maximum. Thanks
£150 GBP in 3 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hey, I'm a UK based professional developer and I've recently worked on a project quite similar to this one. Drop me a message as I have some questions about your requirements. Thanks, Connor
£175 GBP in 3 days
5.0 (1 review)
2.2
2.2
User Avatar
Hi, I've been in excel vba for 3 years and currently creating company tools for users reporting. I can help you with your project but creating vba macro for you. Please let me know to discuss further your requirements. Thanks, Marlou
£166 GBP in 2 days
2.3 (6 reviews)
4.1
4.1
User Avatar
I am an engineer who has worked in large data analysis, customer service, product marketing and general business development. I have an MBA from MIT Sloan. Also, my training and experiences span engineering designs and implementation, renewable energy (biogas), consumer analysis, and general scientific research. I would rate myself 9/10 in the use of Microsoft Excel. I will deliver a top-notch project in a very timely manner.
£250 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i think it was easy to me i have aperfect skills at excel ican do any thing on it , iam amicros maker (forms vbe excel)for control any sheet
£111 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Crawley, United Kingdom
5.0
3
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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.