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.
20 freelancers are bidding on average $81 for this job
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 !
Hello sir, I am an excel and Visual Basic [url removed, login to view] 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!
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
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
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.