Completed

Script to append data from 1 excel file to another excel file automatically - Phase 2

This is Phase 2 of project. I have some raw files that are automatically generated and dropped into a single folder every day.

I also have some master files which are similar to the raw files but they contain the combined data of the raw files, i.e raw file day 1 + raw file day 2 + raw file day 3 + ... + raw file day n = master file. Some master files have additional calculated columns with formulas based only the raw data.

Currently every day I open the raw files and copy the data from the raw files and paste them to the master files. For those master files that have additional calculated columns, after I paste the data from the raw file to the master file, I then copied those calculated columns down.

I need a script that can perform the above steps for me automatically every day at a set time.

Skills: Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps

See more: how to append data in excel using vba, macro to append data in excel, how to append data in excel 2010, how to append data in excel cell, how to append data to a worksheet in excel, excel append data from multiple sheets, how to append data in excel 2016, how to append data in excel 2013

About the Employer:
( 1 review ) Turrella, Australia

Project ID: #16108452

Awarded to:

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

$130 AUD in 3 days
(543 Reviews)
8.1

6 freelancers are bidding on average $144 for this job

seaanddream

Hi, my name is Sevinc. I read your "Script to append data from 1 excel file to another excel file automatically - Phase 2" project descriptions carefully before bidding. I checked your requirements as well... I got w More

$200 AUD in 3 days
(232 Reviews)
7.4
nagyzoltan68

Hello, I would like to work on your project. I have great experience using excel, data manipulation in excel, working with multiple files with transferring data with / without changing data format.

$100 AUD in 2 days
(94 Reviews)
6.0
Anasra

Hi I am Excel Expert and will do for you as you need. Thank you AMir Ishfaq .....................................................................

$30 AUD in 0 days
(43 Reviews)
5.1
prakashmondal

Hi, I am interested to develop vba script in order to read from many raw files in to a master file after click on a button or any other even. Please consider my bid and experience. Regards Prakash

$250 AUD in 3 days
(19 Reviews)
4.7
polarjin2017

Hello? I have good skills in excel projects so i can help you then if you want. You can see my reviews. I will never disappoint you then. Thanks.

$155 AUD in 3 days
(16 Reviews)
4.8