Find Jobs
Hire Freelancers

Excel csv export macro

$10-30 AUD

Terminado
Publicado hace casi 9 años

$10-30 AUD

Pagado a la entrega
Our accounting system requires two csv files to import product purchases. These csv files need to have particular column headings including product codes, descriptions and prices. I would like to enter the information in an Excel worksheet and be able to press a macro button that formats and exports and saves the required information into two separate csv files ready for importing into the accounting system. I can see that this can be done by examples on the internet and would like someone to set it up in the attached Excel spreadsheet. Online examples: [login to view URL] [login to view URL] Avoid using named ranges if possible and stop when there is no more data.
ID del proyecto: 8298857

Información sobre el proyecto

20 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
Adjudicado a:
Avatar del usuario
Hi, i m serious freelancer with 100% completion rate and i believe i can do this for you. As far as i see, you will have only first sheet "Invoice data" and from that sheet two other sheets are created (Products and Purchase order) after those 2 sheets are created they are exported as csv (like in your example in the last sheet). (Generated csv, not using save-as, so you can get results exactly as you want them).This is really simple work it will take me around 2h (max), probably less then that. So please send me a message. Edit: "I m not sure if you already chose a freelancer, but i created a demo for you that works exactly as you specified, this is interesting project for me so i had a little fun doing it, so if you are interested please pm me and i will send you a demo to check." Thanks, Milan
$25 AUD en 0 día
5,0 (59 comentarios)
5,0
5,0
20 freelancers están ofertando un promedio de $24 AUD por este trabajo
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
$35 AUD en 3 días
4,9 (64 comentarios)
5,7
5,7
Avatar del usuario
hey there....we had a look at all the 4 sheets...we can get the required format from the input sheet "Invoice Data"...please reply...we can get it started...thank you...
$24 AUD en 1 día
4,8 (140 comentarios)
5,7
5,7
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.
$45 AUD en 2 días
5,0 (49 comentarios)
5,5
5,5
Avatar del usuario
Hi. I have exp in excel vba macro. I have done alot of similar projects. I am ready to do for you. Thanks!
$24 AUD en 1 día
4,8 (44 comentarios)
5,3
5,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 give reference of my online work portfolio once I heard from you. I am very much able to work on this. ***I am ready to start with thanks and regards
$24 AUD en 2 días
4,5 (41 comentarios)
5,5
5,5
Avatar del usuario
I have created many macros, I will be able to this one as well. You want the CSV stored in the same file in a separate sheet as shown or in a file. Please message for a discussion
$15 AUD en 1 día
4,9 (28 comentarios)
4,4
4,4
Avatar del usuario
A proposal has not yet been provided
$15 AUD en 1 día
5,0 (23 comentarios)
3,5
3,5
Avatar del usuario
Experts are availble to develop macro for you.
$30 AUD en 2 días
4,8 (3 comentarios)
2,9
2,9
Avatar del usuario
I started working in Excel since the start of my career in 1998. MS Office used to come along-with Windows 95 installation at that time. I have experience in developing data enter/edit functionality in MS Excel using VBA, i.e. using a spreadsheet for Data-entry form and another one for Data-storage. Can deal with any kind of complexity related to VBA and Excel formulas. Have vast experience with Excel Pivot Tables and Graphs as well. I'm available for any discussion on Phone (0456 300 001) or Skype (Id: barkatmulani).
$25 AUD en 1 día
4,8 (4 comentarios)
2,5
2,5
Avatar del usuario
hi there... i can start immediately. am a hard worker and can give the best result for u. thank you.
$15 AUD en 1 día
4,7 (2 comentarios)
0,8
0,8
Avatar del usuario
Hello, I am very interested to your project. with my experiences in excel formulas & excel macro I am very confident that i will deliver good result as per your requirement on time. I am new to Freelancer & trying to build a solid profile. i appreciate If you would like to talk thru PM before awarding this project as I'm online now. Hope to hear from you soon. Thank & Regards, gsanggara
$20 AUD en 1 día
5,0 (1 comentario)
0,5
0,5
Avatar del usuario
I have 6+ years working with Excel's VBA in telecommunication industry and I can deliver your file fast. Glad to create a solution for your project. Leopoldino
$40 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Good day sir, We can take this work for low price since our company recently started using Freelancer, Assuring you 100% satisfaction and fast delivery
$15 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
You dont need to recruit me to finish this. Drop me a message, give me a bit time and i can complete it. If you are happy, we can finish the process. (as i need some good references im my profile, i provide this service) I have a 5,5 years of business analyst experience in a global company and 2,5 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. I am mostly online. Just drop me a message so that we can discuss further about pricing and job details. Thanks,
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have already made some similar requests... I can do this for a short time. If you want I can make fast an example during the day? Hope to hear from you! Regards
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I have a working example of such a functionality. If you assign the project to me by today EOD, I can deliver this by tomorrow COB. I am assuming that the example that you shared in the attached Excel file using formula is the exact functionality that you are looking for in the macro. Also I am assuming that the invoice data worksheet layout will not change. The transaction data information will always start from row 5 and it will always have columns A-J.
$15 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Happy to help with this. Located in Sydney. Pm me to discuss further
$30 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Melbourne, Australia
5,0
5
Forma de pago verificada
Miembro desde oct 19, 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.