Find Jobs
Hire Freelancers

Excel Macro Bulk Importing Multiple External Files into Template

$10-60 USD

Terminado
Publicado hace alrededor de 7 años

$10-60 USD

Pagado a la entrega
This project is for Microsoft Excel. Deadline for deliver is Sunday April 30th. 9 files, 11 sheets. Formats will always remain the same. This macro will be for multiple runs, I will be using it weekly and sometimes twice a week. 1) Macro will allow to browse to each file path. Can run Macro for 1 file or all files at once. 2) Symbols will upload from each file one by one with the data attached to its row. 3) Sometimes not all files will be selected, macro will need to run in this situation with 1-9 files. 4) All files will remain in this format. 5) Once all symbols from each file is uploaded, they will match and transpose onto one row (see template). 6) I provide the Template format. *Can run Macro for 1 file or multiple files. Reason 1: Sometimes files take too long to import. Reason 2: Sometime user dose not want to import all files (in case on error with 1 file) - Files contain 1 common element, a symbols column. - Each file has the same process, upload symbols with the required columns from the external file into the correct columns into the Matrix Template. Contact me for quick hire. Looking for quick delivery. How fast can you write it ?
ID del proyecto: 13861834

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 7 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
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only.
$60 USD en 1 día
5,0 (264 comentarios)
6,5
6,5
19 freelancers están ofertando un promedio de $69 USD por este trabajo
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD en 1 día
4,9 (385 comentarios)
8,1
8,1
Avatar del usuario
Hi I am Excel Expert and VBA Developer Your description was pretty clear and after seeing template file may would have few questions Time need will be 1 day , approx , maybe just couple of hours So, if interested, contact me Thanks & Regards
$56 USD en 1 día
5,0 (204 comentarios)
8,2
8,2
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I'm an expert in Excel macros. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$111 USD en 1 día
4,9 (180 comentarios)
6,6
6,6
Avatar del usuario
- Can deliver by Apr30 - Can make the program work for 1 file or the files in the specific folder you choose. - I dont see the template and the source format attached, but can the symbols from the source consolidated into the target files. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$100 USD en 3 días
4,7 (53 comentarios)
6,1
6,1
Avatar del usuario
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. You asked two questions - 1. Can run Macro for 1 file or multiple files? Ans: Yes, it is possible to run the macro for 1 file or multiple files. 2. How fast can you write it ? Ans: I can develop the macro within 1 day. I have excellent knowledge and experience of Importing Data from Multiple Files, Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming and Creating Reports. I have done same job before. So, I can do this job nicely. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
$60 USD en 1 día
4,8 (98 comentarios)
5,8
5,8
Avatar del usuario
I can do this task in a couple of hours as i have the experience in writing similar macros. I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$40 USD en 1 día
4,6 (69 comentarios)
5,4
5,4
Avatar del usuario
Symbols upload? where to upload? Another are okay I think. I've finished some macro projects. I'm waiting your reply to discuss further, Thanks
$50 USD en 2 días
5,0 (46 comentarios)
4,7
4,7
Avatar del usuario
Hi, Excel automation is my expertise. I've been coding vba for 6 years now. I can deliver fast and with high quality. Thanks and best regards, John
$45 USD en 1 día
5,0 (17 comentarios)
3,8
3,8
Avatar del usuario
Hi, I am an excel and vba specialist, I understand what you want and I can finish your project in 2 days, 30/04/2017 morning maximum.
$66 USD en 3 días
4,9 (6 comentarios)
2,7
2,7
Avatar del usuario
We are interested in doing a FREE demo for you. We have done similar work to your project title and in order for us to proceed we would need to talk over your project as we have a few questions. Our FREE demo is completely free and does show you what you could expect when you hire us. Click on the chat icon below and let's get started.
$60 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I've already done your spreadsheet, I'm just waiting for your confirmation to send you ☺️
$166 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
do this for my day job
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a professional Aerospace Engineer. I am detail oriented and can complete your project within your specifications. I am new to the site and just want to make a little money on the side for supplemental income. Please consider me for your project and I will begin when you are ready. Check out my qualifications and Have a fantastic day!
$40 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Toronto, Canada
5,0
17
Forma de pago verificada
Miembro desde feb 26, 2014

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.