Find Jobs
Hire Freelancers

Automate reporting using Excel

$100-400 NZD

Terminado
Publicado hace más de 8 años

$100-400 NZD

Pagado a la entrega
Spreadsheet Required: New Contact Creation Report Frequency: Run Weekly (on a Wed) Trigger: Run Manually by users Purpose: To confirm whether customer information entered by staff is complete and can be considered accurate.. Format: MS Excel 2013 Inputs: 1. Customer - an XL Spread Sheet 2. Vehicle - an XL Spreadsheet 3. TPSTable - an XL Spread Sheet Output CreationCCS New Record Creation.DDMMYY1-DDMMYY2 - an XL SpreadSheet Samples of input files and output file included. Where DDMMYY1 – DDMMYY2 is the preceding Monday to Sunday when the extraction is done. Please ask questions...
ID del proyecto: 9252356

Información sobre el proyecto

28 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
Adjudicado a:
Avatar del usuario
Hello, I am Excel and VBA expert. I can complete this project. Sheet "Customers" column I must of course include the names. Please note that I have 100% completion rate and 5-star feedback on projects.
$100 NZD en 3 días
5,0 (42 comentarios)
5,0
5,0
28 freelancers están ofertando un promedio de $202 NZD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$315 NZD en 2 días
4,9 (232 comentarios)
7,5
7,5
Avatar del usuario
A proposal has not yet been provided
$400 NZD en 3 días
5,0 (204 comentarios)
6,8
6,8
Avatar del usuario
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$260 NZD en 3 días
4,9 (89 comentarios)
6,4
6,4
Avatar del usuario
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$350 NZD en 10 días
5,0 (87 comentarios)
6,0
6,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 PS. Would ask many questions. The file attached is output expected. It has three sheets: Customers, Vehicles and Tables. I guess Tables is the final goal. Would ask questions on tables if the guess is correct.
$100 NZD en 2 días
5,0 (144 comentarios)
5,8
5,8
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$125 NZD en 3 días
4,9 (62 comentarios)
5,8
5,8
Avatar del usuario
I am an ACCA (UK) professional , APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience in advanced use of MS Excel, I can guarantee getting the job right the first time. Feel free to view my 100% positive reviews before you hire me and rest assured that you will receive top-quality work at an affordable cost. Kind regards, Javed
$263 NZD en 3 días
4,9 (56 comentarios)
5,7
5,7
Avatar del usuario
Hi there. I am a professional programmer with more than 6 years of experience working using MS-Excel, including VBA macros. I can guarantee you excellent results and deliver as soon as possible. I appreciate the clarity of your explanation and I am positive I can deliver what you are looking for. I have checked out the input and output files, and everything looks fine but I would like to discuss further details with you. Thanks, Daniel
$299 NZD en 3 días
4,9 (30 comentarios)
5,7
5,7
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 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel 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.
$105 NZD en 2 días
4,8 (61 comentarios)
5,6
5,6
Avatar del usuario
I can do it for you quickly and exactly .
$150 NZD en 3 días
4,9 (53 comentarios)
5,1
5,1
Avatar del usuario
Hi, I am a scientist by profession with extensive experience in creating Excel-based report generation templates for communicating analytical results with clients. I believe I will be able to create an easy-to-use and attractive reporting template for your purposes. I will be able to add some VBA modules to allow you to import the input Excel sheets directly into the template with a simple button interface, and I can a separate VBA module to allow you to export the generated report as a .PDF or separate Excel file from the template. I will need some samples of the input spreadsheets, and the work will be done assuming that the input sheets are always formatted in the same way. I will also need some confirmation of what requirements some formulas need to meet to generate certain results. Please contact me if you have any questions, and please see my portfolio for some previous examples of my work. The bid price may be negotiable. I estimate that I should be able to have to project completed by the end of the week, or by Saturday afternoon at the latest. Thanks for your consideration, Dan
$110 NZD en 3 días
5,0 (23 comentarios)
4,3
4,3
Avatar del usuario
I am interested in this project. I am very skilled with Excel and I would like to hear more about this workbook that you want to create. From what I saw and your description, I would say it is a challenging task. Please contact me for more details.
$200 NZD en 3 días
4,9 (32 comentarios)
4,3
4,3
Avatar del usuario
Hello , I would like to work on your project. I have great experience using excel, and macros / vba. I did not find which is the "TPSTable " in your attachment. We can discuss details in PM. Thank you. Regards
$100 NZD en 3 días
5,0 (39 comentarios)
4,1
4,1
Avatar del usuario
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement. Over 8 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay
$111 NZD en 4 días
4,8 (6 comentarios)
3,2
3,2
Avatar del usuario
Hello! I am interested in your project and would like to take it. Currently i am free and and can start working as soon as i get the project. I have done a similar project like this a few days ago. i would like to have more information about your project. We can discuss more in messages.
$100 NZD en 3 días
5,0 (5 comentarios)
3,1
3,1
Avatar del usuario
I went through the sample file and I believe that you need to generate data as in sheet "table", taking input from the other 2 sheets. (along with a confirmation dialog and the dates). I have a very good hold on excel and have completed similar projects before. I can do this task within 3 days (earlier if required). Thanks
$150 NZD en 3 días
5,0 (3 comentarios)
2,6
2,6
Avatar del usuario
Dear employer, I understand your need. You want an Excel file which can automatically generate a new file with given frequency and it also should be enabled to generate by hand. I can do it for you right now. 1) I will do it with VBA embedded in MS Excel with a timer to do work automatically and a button for you to generate what you want by one click. 2) Questions:Which part of data in the file will be entered by the staff? I see the new worksheet, is it the product you want to be generated? Where should I operate on, I mean which file? 3) Please give me a chat, at least I can give you some suggestions, thank you.
$111 NZD en 3 días
4,4 (2 comentarios)
1,9
1,9
Avatar del usuario
done many projects like this...
$166 NZD en 1 día
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
A proposal has not yet been provided
$257 NZD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a Finance professional and will consider your work as my work. Thanks Regards, Yogesh Goyal India
$277 NZD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de NEW ZEALAND
Auckland, New Zealand
5,0
1
Forma de pago verificada
Miembro desde ene 7, 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.