Find Jobs
Hire Freelancers

Create a production chart MACRO

$30-250 CAD

En curso
Publicado hace casi 8 años

$30-250 CAD

Pagado a la entrega
Hi, I need a MACRO that I will be able to use on any computer (so you may need to create a button) This excel file has TWO Tabs, the first tab is the raw data. This is the report I get when I download it and it will always remain the same. STEP 1 : There are two columns highlighted in BLUE Labelled SALE and SALE2. You need to to first add these columns together Step 2: The macro needs to add SALE and SALE 2 together and labelled it SALES and then delete all the other columns that are not green or your new variable called SALES Step 3: Then create a column called FLOW. to get the flow we divide SALES BY TIME (you need to create a formula that can handle this or USE =(E6/(VALUE(D6)*24)) Step 4: Add another column named feedback and use a (+) in green or (-) for anyone who is above the required flow or under it. (-) means under and (+) means the same or under Step 5: Use conditional formatting on the Sales (where the highest sales is highlighted in green) Step 6: Use conditional formatting on the FLOW where the highest flow is highlighted in green) Let me know if you need anymore advice .Need it for tonight
ID del proyecto: 10250008

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 8 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
9 freelancers están ofertando un promedio de $121 CAD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$200 CAD en 0 día
4,9 (249 comentarios)
7,0
7,0
Avatar del usuario
I can do it for you quickly and exactly
$100 CAD en 2 días
4,9 (90 comentarios)
6,3
6,3
Avatar del usuario
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping, VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$147 CAD en 3 días
4,8 (72 comentarios)
5,8
5,8
Avatar del usuario
I am a Chartered Accountancy student providing an array of services relating to Microsoft office with Excel and word being my area of expertise . I have been providing troubleshooting on macros for other clients and have got great reviews for the same. I can start today and provide the output by the end of day.
$100 CAD en 1 día
4,9 (28 comentarios)
4,9
4,9
Avatar del usuario
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel, VBA. Currently working in an MNC Analytical company on a large financial model including macros for dashboards and presentation, for a leading US bank. I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
$70 CAD en 1 día
4,6 (14 comentarios)
3,9
3,9
Avatar del usuario
I can very work well with creating conditional formatting in user-defined macros, as well as mathematical equations.
$144 CAD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am able to do this job with all the requirements you said, and i am able to do it fast. I have already made a lot of plans using VBA (macro) and even small "systems". And you have also gave one example of the plans that you are going to use (the model). So, this is not going to be difficult to do. Only one question. When you said "it will always remain the same", does it means that every time the columns number and its titles will not change? If this is true, then the work should be a little bit easier.
$35 CAD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Scarborough, Canada
5,0
5
Forma de pago verificada
Miembro desde feb 10, 2016

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.