Find Jobs
Hire Freelancers

Break summary Macro

€8-30 EUR

Terminado
Publicado hace más de 10 años

€8-30 EUR

Pagado a la entrega
I have several excel workbooks saved in various different folders. I want a macro which will be used to compile a summary of the other workbooks. So the macro should: 1) look for a certain workbook names in a certain folders (wb name and folder path will be listed on a tab of the macro, called "File names"). It will tick off or highlight in some way workbooks its finds with match the name, and if some are missing it will skip and go to the next workbook 2) Then look for two certain words in column A and copy the row for cell A to AA for any any data between these two words (The words are "Cash Breaks" and "Misc Adj". Cash breaks will always be above misc adj. If these two names are not found on each tab it checks please flag according on "File names" tab on macro and skip to next tab on workbook. 3) The macro will ignore certain tabs on the workbooks, like any tabs starting with"_" or called "Raw Data" or "GL" 4) It will paste the data copied back into one tab on the macro on column C. And in Column A it will have the workbook name the data came from, and in column B it will have the tab name the data came from. 5) Macro will end by saving results in a folder and pop up a text box with a warning of either "All workbooks found and included in results" if all workbooks on list were found and the two names on each tab it looked in where present or "Some workbooks data were not found, please check "file list" for more details" That's it, if you need some dummy data, I can gladly send you on a few workbooks to demonstrate what I mean etc, hopefully this will be a fairly straightforward project as I have lots of future work I need done which will be more complicated, all excel based. Thanks,
ID del proyecto: 5113847

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 10 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
Dear Gerski, VBA expert here.. Please share the files and get it done within few hours... Please check some samples of my work here: 1. Countdown - [login to view URL] 2. Speedometer based on values- [login to view URL] 3. Integration with Browser - [login to view URL] And you can also check rest of my videos on my youtube channel - [login to view URL] Best Regards, Microk [login to view URL]
€20 EUR en 3 días
4,9 (23 comentarios)
4,3
4,3
12 freelancers están ofertando un promedio de €26 EUR por este trabajo
Avatar del usuario
Hi Gerski, Would need some dummy files to test with and have a question regarding the folders. Could I assume the folders to be residing within a certain folder ? - The folder will be specified as input by the user. Please confirm and I can start working on it. Cheers, Arul
€35 EUR en 1 día
5,0 (77 comentarios)
5,4
5,4
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with positive response. Thanks.
€30 EUR en 3 días
5,0 (16 comentarios)
4,7
4,7
Avatar del usuario
Excel Expert freelancer here with over 10+ years of experience . I have done similar kind of project. I can go through this very easily. Please check my review and ratings. I can complete this within a day
€30 EUR en 2 días
4,9 (33 comentarios)
4,4
4,4
Avatar del usuario
Hello - 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 zero failed projects 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 working version of file before you award me the project. Thanks, Jay
€29 EUR en 3 días
5,0 (22 comentarios)
4,2
4,2
Avatar del usuario
Hi, I will be happy to write that macro for you. Please send me the master file and a sample data file together with folder names and I will start on it right away
€44 EUR en 0 día
5,0 (12 comentarios)
4,1
4,1
Avatar del usuario
Have 16+ years of experience in IT field. Well versed with Excel, Excel Macro Word. Data Entry. Will complete the job in time. Looking Forward to get this job. Have experience in writing Excel Macro. Thanks Satish Kadam
€24 EUR en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hello! i can do anything you need in excel . if you need faster then 2 days you must tell me and i can hurry up and delay my other projects. thank you
€24 EUR en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€23 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€14 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
€23 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello! I have great experience programming in VBA for Excel, Word and Access, so I can do this job for you with joy. Thank you.
€14 EUR en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de IRELAND
Dublin, Ireland
4,9
3
Forma de pago verificada
Miembro desde nov 10, 2013

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.