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.
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.
51 freelancers están ofertando el promedio de £130 para este trabajo
Hi I have read your job description carefully i can start right now. Relevant Skills and Experience VBA, C#, Data Processing, Excel Proposed Milestones £150 GBP - complete