Find Jobs
Hire Freelancers

Creating an Excel VBA Macro Script

$30-250 USD

Terminado
Publicado hace alrededor de 9 años

$30-250 USD

Pagado a la entrega
I need someone to develop an excel VBA macro script. The script would automate the process of combining multiple excel files into 1 large existing table. I get multiple excel files that are all formatted the same exact way every month, each file has the same column names. I need the script to read the files from a specific folder on my computer, combine them (no calculations, each row is unique), and then insert them into an existing table in my worksheet. The existing table is essentially cleared of old data and this new combined excel data is inserted into the table every month. The number of files that need to be combined and inserted into the existing table changes over time, the script needs to simply identify all files in a specific folder. A more detailed project description and sample excel sheets will be provided to selected professionals following their bids. The macro will be provided in an open source format. The copyright and all rights on the macro will be mine. The professional should be available via Skype if needed, but email might be sufficient. Kind regards ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform Windows 7
ID del proyecto: 7479449

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

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:
Avatar del usuario
Hello, I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix. I have created a couple of similar projects in the past, I could use the templates to speed up the process for what you need. Can you please give me a estimate files count and total rows count? because if we're talking about >1mil lines then it needs to be designed differently. Please let me know if you think you need me and we'll take it from there. Thanks!
$98 USD en 3 días
5,0 (9 comentarios)
3,7
3,7
11 freelancers están ofertando un promedio de $70 USD por este trabajo
Avatar del usuario
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$45 USD en 1 día
4,9 (55 comentarios)
5,6
5,6
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$150 USD en 4 días
4,9 (43 comentarios)
5,2
5,2
Avatar del usuario
Hello Sir. Im excel VBA macro and formula Expert. I can combine your many file to 1 file Sir :). please give me your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
$30 USD en 1 día
4,9 (34 comentarios)
4,6
4,6
Avatar del usuario
Hi there! I am a doctoral research scholar working at the Indian Institute of Technology (IIT) Delhi. I have extensive experience in using MS Excel with Visual Basic Application (VBA) for manipulation. I am hopeful of providing you a valuable service. Thank you. Warm regards, Naseef Ummer
$133 USD en 3 días
5,0 (4 comentarios)
3,0
3,0
Avatar del usuario
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$40 USD en 0 día
4,8 (10 comentarios)
2,9
2,9
Avatar del usuario
I have 7+ years of experience in software industry. ASP .Net, C#, VB .Net, Visual Basic,SQL Server, MySQL,Bootstrap, Telerik, Access,Excel VBA, Crystal Report is my working area. I am confident to complete your requirement.
$150 USD en 3 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
Hi, I have worked in a very simmilar project before and this can be done withing 2-3 hours. Please consider my bid. Thanks, Arpan
$30 USD en 1 día
5,0 (2 comentarios)
0,6
0,6
Avatar del usuario
With over 15 years experience as a software and mechanical engineer I've created numerous spreadsheets to perform similar import tasks. I've worked with people in a wide range of industries, including medical devices, transportation, education, and toolmaking. I can create a macro allowing you to set up parameters for the import, including storage location. All code will be fully owned by you and can be edited by you or or business as you see fit. If so desired I can be available for long term support in the event future changes to your input files require updates to the macro. Feel free to contact me with questions
$100 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
La propuesta todavía no ha sido proveída
$45 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Đề xuất vẫn chưa được gửi
$35 USD en 3 días
0,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Brooklyn, United States
5,0
2
Forma de pago verificada
Miembro desde abr 13, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.