Select data from 100 individual Excel spreadsheets and compile in a summary spreadsheet

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.

Habilidades: Excel

Veja mais: job summary, spreadsheets, already completed modification, excel compile data, compile excel files, name select, excel large data, excel manual data, summary excel, 100 excel, excel automated, paste files excel, grab data multiple excel spreadsheets, copy data word excel spreadsheet, data missing excel spreadsheet, data export excel spreadsheet web form, convert data word excel spreadsheet, free data entry excel spreadsheets, excel macro select data cut paste, paste data pdf excel spreadsheet, amazon yahoo excel spreadsheets data entry, data entry excel spreadsheet, spreadsheet compile, paste excel files, excel cut

Acerca do Empregador:
( 22 comentários ) Sydney, Australia

ID do Projeto: #6841747

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.

$100 AUD em 1 dia
(134 Comentários)

18 freelancers estão ofertando em média $85 para esse 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

$50 AUD in 0 dias
(323 Comentários)

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

$150 AUD in 3 dias
(165 Comentários)

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

$105 AUD in 2 dias
(171 Comentários)

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

$45 AUD in 3 dias
(301 Comentários)

Hi... Thanks for inviting me. I understood the project and will submit it within the time limit. Thanks Rohit Pithisaria

$111 AUD in 3 dias
(101 Comentários)

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

$45 AUD in 0 dias
(140 Comentários)

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 !

$35 AUD em 1 dia
(143 Comentários)

Hello sir, I am an excel and Visual Basic [login to view URL] can be done manually,but for reducing errors I will write a code in vba to do this copy paste job. Please check my reviews and contact me. Kind regards, Dragos!

$50 AUD em 1 dia
(85 Comentários)

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. (tasleemnaz Mais

$100 AUD in 3 dias
(79 Comentários)

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

$45 AUD in 3 dias
(5 Comentários)

Hi, I am post graduate in Computer Applications and having good typing speed. I assure you to complete your task with in time with 100% accuracy.I understand a freelancer's responsibilities very well. You can trust m Mais

$100 AUD in 3 dias
(2 Comentários)

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

$200 AUD in 3 dias
(0 Comentários)

A proposal has not yet been provided

$155 AUD in 3 dias
(0 Comentários)

Proposal belum diberikan

$66 AUD in 3 dias
(0 Comentários)

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

$35 AUD in 3 dias
(1 Comentário)

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.

$35 AUD em 1 dia
(0 Comentários)

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,

$100 AUD in 2 dias
(0 Comentários)