Find Jobs
Hire Freelancers

Creating a macro in Excel

$10-30 CAD

En curso
Publicado hace más de 8 años

$10-30 CAD

Pagado a la entrega
I need a macro created for extracting, sorting and formatting data. There is a file attached for steps that I take manually to extract the information. I need the same steps created in a macro. Also attached is a raw data that you will be using to create the macro. This raw data is very simple, but the macro needs to be able to work with small and large amount of data. You will only get paid if the macro works. We will test the macro with various types of data and if it works then the payment will be issued.
ID del proyecto: 8267544

Información sobre el proyecto

26 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
26 freelancers están ofertando un promedio de $52 CAD por este trabajo
Avatar del usuario
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
$120 CAD en 3 días
5,0 (224 comentarios)
7,4
7,4
Avatar del usuario
A proposal has not yet been provided
$100 CAD en 1 día
4,9 (256 comentarios)
7,6
7,6
Avatar del usuario
I can do it for you quickly and exactly. . . .
$111 CAD en 3 días
4,9 (115 comentarios)
7,0
7,0
Avatar del usuario
A proposal has not yet been provided
$30 CAD en 2 días
4,9 (366 comentarios)
7,0
7,0
Avatar del usuario
A proposal has not yet been provided
$29 CAD en 2 días
4,8 (221 comentarios)
7,1
7,1
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, models and macros. Check my reviews. They speak for themselves. Best regards
$122 CAD en 3 días
4,9 (241 comentarios)
7,0
7,0
Avatar del usuario
I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the factors in your project.
$20 CAD en 1 día
5,0 (84 comentarios)
6,3
6,3
Avatar del usuario
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$24 CAD en 2 días
4,7 (58 comentarios)
5,8
5,8
Avatar del usuario
I am willing to discuss further about the project details and deliver the same to your needs and specifications.
$44 CAD en 1 día
4,8 (25 comentarios)
5,5
5,5
Avatar del usuario
I have questions to ask as your document needs more explanation. Other than that, it seems easy. But if possible, I want to see the original data and work with it. Regards
$55 CAD en 1 día
5,0 (21 comentarios)
4,4
4,4
Avatar del usuario
Sir/Madam, Good day! I'm a degree holder and I'm an expert in excel/spreadsheet with experienced in vb in excel, vlookup, automated formulas, macro, HD charts and figures, etc. I'm also a virtual assistant for 3 years doing excel jobs. You will find me to be motivated and hardworking individual. Please contact me now. Thank you.
$25 CAD en 1 día
4,9 (2 comentarios)
3,3
3,3
Avatar del usuario
Hi, Please send a message so we can discuss your requirements. Also, I already have a file which does a similar job. I can send the sample file to you. Thanks, Chris
$45 CAD en 1 día
5,0 (9 comentarios)
3,3
3,3
Avatar del usuario
A proposal has not yet been provided
$25 CAD en 1 día
4,9 (6 comentarios)
2,9
2,9
Avatar del usuario
Hi! I checked your files, all is possible. I could do it in 1-2 days, but few days are necessary to check and to make adjustments if needed.
$30 CAD en 4 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
i'm working in data processing corp. as data editor, we frequently create macro to automate task, i'm an IT grad, knows VBA and visual basic
$77 CAD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 CAD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have done simular projects in my workplace. I optimized my own monthly reports, and I now do them for 15 minutes, instead of the 6 hours they took before automatization. Depending on the complexity of the macro, I can deliver much faster than 2 days. I am Excel proficient user. I use macros for more than 2 years. I have successfully completed projects, saving 5-6 manhours per run (on a report, executed every day). I do formatting macros, work with pivots, tables, file operations (splitting 1 sheet of data for different clients to separate files for all the clients, named with specific naming conventions), Outlook (meeting requests based on excel source, mailing distribution based on excel source). My most complex project is generating metrics report for 60-70 accounts, using different tools with different tool logic (hence metrics logic for each), which serves the managerial team of my unit with all information they need on the monthly performance. Manually (with standart excel features, including formulas and pivots), reporting all metrics would take more than a manmonth, due to the poorly structured data in the tools, we now do it in a day. I provide post-implementation support of the macros, if such is needed
$35 CAD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am an advanced excel user and I have the skill set to complete this task. In my previous role I created a number of macros for sorting and formatting large amounts of data so that it can presented in a more manageable way. Before getting started I would like to discuss the outcome that you are trying to achieve from the process that you have laid out. I understand that these are the steps you take when doing the process manually but sometimes there are better/faster/easier ways of achieving the same result with a macto. I see the final picture shows a table that is colour coded based on the results, but some understanding of what it is would greatly help. I believe I am an excellent candidate for this job and I am a native English speaker (originally from New Zealand and recently moved to Poland). I believe this is key to understanding the requirements of the job and ensuring that I provide you with what you need. Kind regards, Sam
$160 CAD en 6 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have worked extensively with Excel, VBA, Financial Modelling and Dashboards. I enjoy creating files that are easy to use and re-use, give meaningful answers and assist with accurate decision making for business. I would be available to discuss this further if required.
$35 CAD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$50 CAD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Burlington, Canada
5,0
55
Forma de pago verificada
Miembro desde ago 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.