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.
48 freelancere byder i gennemsnit £135 på dette job
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
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.