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

$30-250 AUD

Completed

Posted

over 6 years ago

$30-250 AUD

Paid on delivery

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.

Visual Basic for Apps

Project ID: 16108452

About the project

6 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Thanks, Jay

$130 AUD in 3 days

5.0

(543 reviews)

8.1

6 freelancers are bidding on average $144 AUD 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 what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.

$200 AUD in 3 days

4.9

(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

5.0

(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 day

4.8

(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