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 Bearbeitung
Veröffentlicht vor fast 6 Jahren

£20-250 GBP

Bezahlt bei Lieferung
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.
Projekt-ID: 17225165

Über das Projekt

39 Vorschläge
Remote Projekt
Aktiv vor 6 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 Tagen
5,0 (64 Bewertungen)
5,3
5,3
39 Freelancer bieten im Durchschnitt £133 GBP für diesen Auftrag
Avatar des Nutzers
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 Tagen
5,0 (1186 Bewertungen)
8,4
8,4
Avatar des Nutzers
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 Tagen
4,9 (589 Bewertungen)
8,5
8,5
Avatar des Nutzers
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 Tagen
5,0 (222 Bewertungen)
8,4
8,4
Avatar des Nutzers
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 Tagen
4,9 (73 Bewertungen)
6,9
6,9
Avatar des Nutzers
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 Tagen
5,0 (213 Bewertungen)
6,6
6,6
Avatar des Nutzers
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 Tagen
4,9 (138 Bewertungen)
6,5
6,5
Avatar des Nutzers
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 Tagen
4,9 (108 Bewertungen)
6,3
6,3
Avatar des Nutzers
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 Tagen
4,9 (38 Bewertungen)
5,9
5,9
Avatar des Nutzers
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 Tag
5,0 (158 Bewertungen)
5,9
5,9
Avatar des Nutzers
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 Tagen
4,8 (69 Bewertungen)
5,8
5,8
Avatar des Nutzers
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 Tagen
4,9 (64 Bewertungen)
5,7
5,7
Avatar des Nutzers
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 Tagen
5,0 (39 Bewertungen)
5,4
5,4
Avatar des Nutzers
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 Tag
4,9 (54 Bewertungen)
5,5
5,5
Avatar des Nutzers
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 Tag
4,8 (13 Bewertungen)
4,6
4,6
Avatar des Nutzers
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 Tagen
4,9 (16 Bewertungen)
3,9
3,9
Avatar des Nutzers
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 Tagen
5,0 (2 Bewertungen)
2,7
2,7
Avatar des Nutzers
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 Tagen
5,0 (1 Bewertung)
2,2
2,2
Avatar des Nutzers
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 Tagen
2,3 (6 Bewertungen)
4,1
4,1
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED KINGDOM
Crawley, United Kingdom
5,0
3
Zahlungsmethode verifiziert
Mitglied seit Feb. 13, 2017

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.