I gang

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

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.

Evner: Dataindførsel, Databehandling, Excel, Software Arkitektur, Visual Basic

Se mere: combining data from multiple excel files python, merge excel files into one using python, python combine multiple excel files, python combine excel files into one, combine multiple excel files into one workbook separate sheets python, tableau union different connections, tableau union custom sql, merge multiple excel files into one python, create program for extract product data from particular online shop 2, create program for extract product data from particular online shop -- 2, excel macro create spreadsheet template list data, create spreadsheet access vba, create spreadsheet monitor workflow, vba create spreadsheet xml, create spreadsheet gathering emails, wordpress create spreadsheet, create spreadsheet form, create spreadsheet compile data, send calculation create spreadsheet, person create spreadsheet

Om arbejdsgiveren:
( 2 bedømmelser ) Crawley, United Kingdom

Projekt ID: #17225165

Tildelt til:

Taisho

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 p Flere

£105 GBP in 3 dage
(55 bedømmelser)
4.8

46 freelancere byder i gennemsnit £134 på dette job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Flere

£200 GBP in 3 dage
(644 bedømmelser)
8.3
cgullapalli

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. Flere

£150 GBP in 3 dage
(809 bedømmelser)
7.9
schoudhary1553

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, Dat Flere

£150 GBP in 3 dage
(308 bedømmelser)
7.7
Eagles90

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. Yo Flere

£200 GBP in 4 dage
(138 bedømmelser)
7.8
best4best

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 dage
(191 bedømmelser)
6.5
katilinas

Greetings, I'm ready to work on "create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and then create a .csv output" project. I have 5 years experience in Visual Basic, Excel. 120 GBP - Flere

£120 GBP in 2 dage
(122 bedømmelser)
6.4
vlayausa

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 Flere

£74 GBP på 1 dag
(144 bedømmelser)
5.8
royalcalif

Let me review the spreadsheet for the appropriate duration and cost as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I Flere

£20 GBP på 1 dag
(85 bedømmelser)
5.5
PerfectChoic3

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 dage
(68 bedømmelser)
5.8
nagybatonyi

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 macr Flere

£88 GBP in 2 dage
(62 bedømmelser)
5.7
abdolah2014

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 ................................................................... Flere

£111 GBP in 3 dage
(39 bedømmelser)
5.4
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac Flere

£150 GBP in 3 dage
(33 bedømmelser)
5.5
sherifamgadnabih

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 dage
(27 bedømmelser)
5.5
carlosperezit

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 på 1 dag
(51 bedømmelser)
5.4
aimefx

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 wi Flere

£100 GBP in 3 dage
(43 bedømmelser)
5.4
sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Flere

£50 GBP på 1 dag
(83 bedømmelser)
5.3
c4cuteconain

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 dage
(36 bedømmelser)
5.0
£50 GBP på 1 dag
(41 bedømmelser)
5.2
£150 GBP in 3 dage
(24 bedømmelser)
4.4
antoinepal

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 Flere

£183 GBP in 3 dage
(16 bedømmelser)
4.4