Find Jobs
Hire Freelancers

Excel csv export macro

$10-30 AUD

Completed
Posted over 8 years ago

$10-30 AUD

Paid on delivery
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.
Project ID: 8298857

About the project

20 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 0 day
5.0 (59 reviews)
5.0
5.0
20 freelancers are bidding on average $24 AUD for this job
User Avatar
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 in 3 days
4.9 (64 reviews)
5.7
5.7
User Avatar
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 in 1 day
4.8 (140 reviews)
5.7
5.7
User Avatar
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 in 2 days
5.0 (49 reviews)
5.5
5.5
User Avatar
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 in 1 day
4.8 (44 reviews)
5.3
5.3
User Avatar
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 in 2 days
4.5 (41 reviews)
5.5
5.5
User Avatar
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 in 1 day
4.9 (28 reviews)
4.4
4.4
User Avatar
A proposal has not yet been provided
$15 AUD in 1 day
5.0 (23 reviews)
3.5
3.5
User Avatar
Experts are availble to develop macro for you.
$30 AUD in 2 days
4.8 (3 reviews)
2.9
2.9
User Avatar
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 in 1 day
4.8 (4 reviews)
2.5
2.5
User Avatar
hi there... i can start immediately. am a hard worker and can give the best result for u. thank you.
$15 AUD in 1 day
4.7 (2 reviews)
0.8
0.8
User Avatar
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 in 1 day
5.0 (1 review)
0.5
0.5
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Happy to help with this. Located in Sydney. Pm me to discuss further
$30 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
5
Payment method verified
Member since Oct 19, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.