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.
Hi Sir I have checked the complete details of the project and will create a macro to import 2 sheets with multiple [login to view URL] Them together. Perform data analysis and macro to export the result as CSV Regards
45 freelancers are bidding on average £134 for this job
Hello Sir, I am interested in this project. I can provide you a more customized solution for this excel project. Please let me know if you would like to discuss. Thanks Aanvik
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Hi, I have experience of working on similar data automation projects. Please let me know if you are interested and I am available to discuss and start right away.