Script to append data from 1 excel file to another excel file automatically

$30-250 AUD

Terminado

Publicado

hace más de 6 años

$30-250 AUD

Pagado a la entrega

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.

Data Processing

Excel

PHP

Software Architecture

Visual Basic

ID del proyecto: 15808924

Información sobre el proyecto

30 propuestas

Proyecto remoto

Activo hace 6 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I 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. Proposed Milestones $250 AUD - Please pay me once job is 100% done. Please initiate a chat before award as I have few queries to confirm so that I can ensure its doable

$250 AUD en 3 días

5,0

(669 comentarios)

8,4

30 freelancers están ofertando un promedio de $117 AUD por este trabajo

@sureshdevi

I will create script to execute daily to combine automatically generated raw file data with master file data and perform some calculations. I will complete this work in 2 days. Relevant Skills and Experience PHP, Excel, Visual Basic Proposed Milestones $64 AUD - after completion of creating script to combine raw file and master file with perform calculations

$64 AUD en 2 días

5,0

(1162 comentarios)

8,0

@semi786

Hi Sir/Mam, It is being my pleasure to introduce you to me. I am expert in advance excel. I have excellent knowledge of advance excel and VBA automation. Relevant Skills and Experience excel, VBA Proposed Milestones $100 AUD - Complete and I know many things in excel like Formulas (Countif, Sumif, Index match, Vlookup and offset etc.), Pivot, validation, macro, Pivot chats etc. Please review my profile. My profile is suitable for this project. I will complete this project within one day. Please give me chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786

$100 AUD en 0 día

5,0

(309 comentarios)

7,7

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Relevant Skills and Experience I have more than 5 years of experience with excellent knowledge in Data Processing, Excel, PHP, Software Architecture, Visual Basic . please give me a chance to work on your project Proposed Milestones $120 AUD - Script to append data from 1 excel file to another excel file automatically

$120 AUD en 3 días

4,9

(338 comentarios)

7,8

@gangabass

I can create simple program that will read raw files and add data into master file just like you want (including formulas). Relevant Skills and Experience I'm desktop automation expert with several projects like this completed that's why I'm sure you'll be impressed with my work. Proposed Milestones $150 AUD - Project completion Can you show me master file and raw file sample?

$150 AUD en 2 días

5,0

(455 comentarios)

7,3

@bestit4u

Hello,sir I have read your post and I am very,very interested in your project. I have much experiences that develop the projects using php,Excel vba... Relevant Skills and Experience I have been working as the software developer for 6 years. My man skills are PHP,Excel VBA,C#,C/C++,Java,python and etc. Proposed Milestones $155 AUD - milestone pls contact me and let's discuss the project . thanks

$155 AUD en 3 días

4,9

(101 comentarios)

7,1

@dpune

I have completed more than 335 projects.

$80 AUD en 3 días

4,9

(167 comentarios)

6,5

@abhi98041

i am a python expert and i can do it for you.

$35 AUD en 1 día

4,9

(149 comentarios)

6,0

@etuannv

Dear Sir, I can do this job. I will use Python to do this job. You just click and get the result. Thank you ! Relevant Skills and Experience python, excel Proposed Milestones $111 AUD - Milestone for project

$111 AUD en 3 días

5,0

(49 comentarios)

5,9

@solucionesnet

Hi, I can build for you an application in vb.net that resides in the system tray to open your files at set time and append to master excel file, share me a sample of raw files and master file. Habilidades y experiencia relevante I'm a senior visual basic .net developer with 5 years of experience, check my desktop application portfolio. Htos propuestos $155 AUD - developt, test and delivery

$155 AUD en 5 días

4,9

(49 comentarios)

5,8

@mail2vimalarora

Hi..having gone through your project details of combining excel as per your requirement, I can provide you efficient solution which will be work as per scheduler and do the activity. Relevant Skills and Experience Technically well versed in handling excel related tasks and writing code for it, based on which I assure you of quick and efficient solution. Waiting for your response for further discussion. Thanks. Proposed Milestones $72 AUD - project fee

$72 AUD en 2 días

4,8

(119 comentarios)

6,0

@khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Financial / Business Analysis & Reporting, Accountancy, Administration, Banking and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.

$150 AUD en 2 días

5,0

(27 comentarios)

5,3

@aubrey03

I am a VBA specialist. I am the best candidate for this task because I already know what needs to be done. This process can be automated by using an Excel macro, this macro can be trigerred upon opening the master file or by using a batch file that will be launched using windows task scheduler.

$100 AUD en 2 días

4,7

(65 comentarios)

5,3

@vmadhavan15

I am not a random bidder.. I hope I can do this one.. as I already have a tool working like the same.. Please ping me if you are interested with my proposal and Thank you. Relevant Skills and Experience VBA Proposed Milestones $83 AUD - final payment

$83 AUD en 3 días

4,9

(24 comentarios)

4,9

@WesleyJeftha

I specialize in Data extraction & automation and aggregation of data using excel. I just delivered a similar project where we automated the collation of multiple files into one normalized data source. Relevant Skills and Experience 1.17 years Excel Experience (also use to lecture this at University) 2. 12 years Corporate business experience 3. Fluent in English 4. I work quickly, accurately and professionally Proposed Milestones $100 AUD - 50% completion of agreed scope $122 AUD - Payment on completion, and after the client is totally satisfied with the end deliverable

$222 AUD en 3 días

5,0

(14 comentarios)

5,0

@kunitsynartem

Hello! I can make such script using Python. It will be collect raw xls files, process them in required way and output in result file at a set time. Relevant Skills and Experience Python 1+ year Proposed Milestones $100 AUD - after the job is done Please, describe more in details what the script should do. And what is the OS you're using?

$100 AUD en 3 días

5,0

(18 comentarios)

4,7

@nelumindralal

Hello, I went thru the des. This can be done within 3 days with 100% accurate. Kindly check my past job work Today can start. Looking forward to hearing from you Thanks Regards Thushara Relevant Skills and Experience Data Processing, Excel, PHP, Software Architecture, Visual Basic Proposed Milestones $133 AUD - once done

$133 AUD en 3 días

5,0

(25 comentarios)

4,3

@chintuag

Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. My expertise in excel includes, but not limited to: Macros, User Forms, Web Scraping, Dashboards, Pivot Tables, Formulas, Interaction with external applications for data exchange (Outlook, PDF, Access). Looking forward to hear from you. Regards Chintu

$101 AUD en 3 días

5,0

(9 comentarios)

4,0

@Carlosemadrizmor

I did that work everyday. I am ready for this. I offer you clean code so you can change when you want. Relevant Skills and Experience Software Engineer, +10 years in Excel (Function, macros, VBA) Simple y quality code Proposed Milestones $30 AUD - You will only pay after I release all the product, you prove it and certify the quality.

$30 AUD en 3 días

5,0

(4 comentarios)

3,7

@tom19468

I will modify my existing MS Excel VBA scripts to copy the data from the raw files and paste them to the master files, copy the additional calculated columns and then copied calculated columns down. Relevant Skills and Experience I have been coding in basic & MS Office (Word, Excel, PowerPoint etc...) VBA script since 2000. I already have a similar VBS script. Proposed Milestones $111 AUD - Project Successfully Completion In what format is your raw data files? How soon do you need this project?

$111 AUD en 3 días