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

Om arbejdsgiveren:
( 1 bedømmelse ) 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
(54 bedømmelser)
0.0

48 freelancere byder i gennemsnit £135 på dette job

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
(34 bedømmelser)
0.0
webxdevelopersl

Hey there . would VBA / Excel expert and can be done in 2 days a) can have a menu based Excel VBA application to make this work . The suggested proposal . [login to view URL] have a menu to import the 2 files by Flere

£222 GBP in 2 dage
(0 bedømmelser)
0.0
£150 GBP in 3 dage
(5 bedømmelser)
0.0
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
(265 bedømmelser)
0.0
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
(37 bedømmelser)
0.0
akweb2015

Hello, I think we have to program which does this automatically. Ready to start to work right away. Thank you.

£277 GBP in 3 dage
(3 bedømmelser)
0.0
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
(49 bedømmelser)
0.0
marloufin

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

£166 GBP in 2 dage
(3 bedømmelser)
0.0
mafersalas

Im a statistics major, almost done with it. I can present proof of this. I can probably deliver in less than 3 days. Ive worked numerous times structuring data in excel. I also have SPSS knowledge and license if requir Flere

£83 GBP in 3 dage
(0 bedømmelser)
0.0
harithgov

Worked with excel vba, ms access and powerpoint automation. have developed softwares using these tools.

£150 GBP in 14 dage
(0 bedømmelser)
0.0
general985

Hello sir. I'm excited about your project, because I've really rich experience in Excel Programming. I've developed many projects similar to yours and excellent skills. If you award me, I'll provide wonderful result Flere

£150 GBP in 3 dage
(9 bedømmelser)
0.0
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
(585 bedømmelser)
0.0
£150 GBP in 5 dage
(0 bedømmelser)
0.0
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
(189 bedømmelser)
0.0
£250 GBP in 3 dage
(0 bedømmelser)
0.0
muzumal

I have a strong experience in data entry and Ms Office.I have a good knowledge of Ms excel and I have prepare in sheets and reports.

£144 GBP in 3 dage
(0 bedømmelser)
0.0
sourabhgupta501

Hi, I am having more than 5 years of exp in related automation using vba and excel. Pricing is negotiable as I am new here and trying to make a place. Looking for a positive response.

£111 GBP in 2 dage
(0 bedømmelser)
0.0
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)
0.0
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
(49 bedømmelser)
0.0
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
(122 bedømmelser)
0.0