Find Jobs
Hire Freelancers

Automate an Excel Spreadsheet with Macros

$10-30 USD

Terminado
Publicado hace casi 10 años

$10-30 USD

Pagado a la entrega
Create a macro that will automatically populate an excel tab rows with running serial numbers. Info to be entered by our operator : Part Number, starting serial numbers and ending serial numbers. There may be up to 20 part numbers with their own starting and ending serial numbers. Info to be generated automatically : Rows of part numbers, with incrementing serial numbers, depending on the ranges entered by our operator. See attached excel sheet for example of data input format and output requirements.
ID del proyecto: 5868185

Información sobre el proyecto

10 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
Hello Valued Client, I have seen your attacment and I believe I can do the work for you in 1 day. I have kept that extra day for communication or other things. In the file I see some columns not marked in yellow, but shows up in the result (like pallet). I see it is by default 1. I'll include this, as well as the 'Count' column (marked in light grey) if you need it. I can automate that the output sheet is named accordingly too. For example for PO of 41103, the resulting sheet shall be named "41103 Output" automatically. I think instead of a button you can make it a normal macro as well. so wheneverthere is data in the first sheet that has a structure like this, it shall create output sheets accordingly. I can make it an excel addin as well, so that the button is in the menu bar (instead of the sheet). All in the same price. So, do message me if you want further discussions. I have done several jobs like this, and this is very easy for me. Thanks & Regards Raad
$25 USD en 2 días
5,0 (33 comentarios)
5,1
5,1
10 freelancers están ofertando un promedio de $26 USD por este trabajo
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. 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
$49 USD en 2 días
4,9 (142 comentarios)
6,4
6,4
Avatar del usuario
In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$25 USD en 1 día
4,9 (62 comentarios)
5,7
5,7
Avatar del usuario
I am An Excel - vba Expert and I can help U pm me ...............................................................................
$35 USD en 1 día
5,0 (38 comentarios)
5,3
5,3
Avatar del usuario
A proposal has not yet been provided
$30 USD en 1 día
4,8 (18 comentarios)
4,2
4,2
Avatar del usuario
Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in VBA project. I can provide you the best cheap prices the best results. If you had interest for my suggestion, please call me. I await for you. Best Regards.
$14 USD en 1 día
5,0 (3 comentarios)
2,4
2,4
Avatar del usuario
Hi Yung Ming Lee, I saw you Excel file along with your macro, and understand your requirement of creating an automated serial numbers, based on the user inputs. I can clearly do the project for you, and moreover I will give an useful view of the sheet, which can be useful for any other analysis. To be honest, I am good in Microsoft Office Package, along with the VBA. You can see my Excel Add-on, that I have created, in my portfolio. I can finish this project in less than a day, hope so, if your objectives does not differ. Thanks for the opportunity. You can contact me at any time.
$14 USD en 1 día
5,0 (3 comentarios)
1,9
1,9
Avatar del usuario
I am a quick learner and hard worker with a sense of team work,I have strict professional and ethnic high sense of confidentiality.i hold excellent communication,organizational and managerial skills and I adapt easily to change social and business environment,kindly i need this job.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SINGAPORE
Singapore, Singapore
5,0
8
Forma de pago verificada
Miembro desde abr 17, 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.