Select data from 100 individual Excel spreadsheets and compile in a summary spreadsheet
$30-250 AUD
Pago na entrega
I have about 100 Excel spreadsheets containing data. These are large files (mostly between 1-10 MB), but only a small amount of data is required from each one.
The required data are located in the same place in each spreadsheet. I require this selected data (and the name of the source spreadsheet) to be copied to a single summary spreadsheet called "Fitted Distribution Summaries".
Once the selected data are copied to the summary spreadsheet, a small amount of data modification is also required.
I require this job to be automated, rather than manual cut-and-paste. This is to reduce the likelihood of introducing errors (as well as to ensure that it can be completed in a reasonable time).
I will provide the summary spreadsheet (called "Fitted Distribution Summaries") with the first few fields already populated to show clearly what is required.
The other 100 Excel Spreadsheets will be shared with the successful bidder via a shared Dropbox folder.
ID do Projeto: #6841747
Sobre o projeto
Concedido a:
Hello I can help you with your project. I'd like to create script that can do all work for you. I can do it in one day. Waiting for your response.
18 freelancers estão ofertando em média $85 nesse trabalho
Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere Mais
Hi, I am good at getting data from different excel spreadsheet and merge the required information in master list. 100% professional service with quality work guaranteed. Hope you would consider my bid and contact. Mais
Hi Sir. I'm excel expert, please see detail my portfolio. I can do your job. please give me detail and i will start doing your job right now Thanks BR Prameswara
Hi, I am an Excel macro expert and would be happy to take on your project. My solution will be Excel macro based wherein user will be prompted to select the Folder containing the input data files. There is no limit Mais
Hey Mate Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality outp Mais
Hi... Thanks for inviting me. I understood the project and will submit it within the time limit. Thanks Rohit Pithisaria
Hey there - are you using Windows ? If so, we can write a small automation script (which can collect the data from all sheets)... Please reply, we can discuss further, thank you !
I have already done like this project. I have many years of experience in Data Entry and Web Research. I put a lot of effort into perfecting every task handed to me. I can help with any admin, virtual, excel, data e Mais
Hello sir I am jimit I read your description and I have experience on php and related technologies i Whoud like to work with you Please allow me personal chat Thank jimit
Hello, I can help you in this.I can start it from now. Please provide me with details. Will be waiting for your reply. Thanks,
I am highly proficient in Excel having worked with it for the last 15 years. I have excellent attention to detail and work quickly and efficiently. I take pride in providing work of high quality and in a timely manne Mais
I'll create an VBA excel macro file to read data in the others one then process them as requested. All things are done via VBA script programming language. Any change of input data can be updated to result data.