Em Andamento

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

Ver 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, data missing excel spreadsheet, data entry excel spreadsheet, spreadsheet compile, paste excel files, excel cut, cut excel, large spreadsheet, excel large data files, large excel files

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

ID do Projeto: #6841747

Premiar a:

igorssv

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
(16 Avaliações)
3.7

20 freelancers estão ofertando em média $81 para este trabalho

Teloquence

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
(231 Comentários)
7.0
FINGERRPRINT

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
(82 Comentários)
6.8
deepbluetech

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
(136 Comentários)
6.4
avinav606lx

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
(77 Comentários)
5.9
expertatwork

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
(74 Comentários)
5.1
dragos1910d

Hello sir, I am an excel and Visual Basic expert.This 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
(44 Comentários)
4.9
talhamunir2002

A proposal has not yet been provided

$54 AUD em 1 dia
(66 Comentários)
4.9
rohitpithisaria

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
(26 Comentários)
4.6
tasleem83

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
(14 Comentários)
3.6
papawady146

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
(1 Comentário)
1.0
kdkul

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)
0.9
jimit6392

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)
0.0
pututkaryadi

Proposal belum diberikan

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

Thank you for this wonderful opportunity. Today Your job posting has caught my attention because Iâ??m keenly considering your job post including these skills. I have excellent experience in Microsoft Office and Admin Mais

$45 AUD in 0 dias
(0 Comentários)
0.0
prameswara

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
(0 Comentários)
0.0
Dona121

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)
0.0
belindafreelance

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)
0.0
jumamoyefjohn

A proposal has not yet been provided

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

I can perform the data entry for you. Please do message me and we can talk about it further. I can start immediately. Thank you!

$150 AUD em 1 dia
(0 Comentários)
0.0
taxakasan

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)
0.0