Find Jobs
Hire Freelancers

Write Excel VBA macro to edit one CSV file to produce two files

$10-30 USD

Completed
Posted almost 9 years ago

$10-30 USD

Paid on delivery
For this project, please write an Excel macro using VBA. The macro will create two output CSV files using one input CSV file. Actions in the macro include deleting rows and columns based on values contained within, rearranging the order of columns, inserting new columns, editing values, and saving the output files with a certain filename format based on the current date. Attached are the specific instructions in "product [login to view URL]". Also attached are a sample [login to view URL] and the two output files that would be created from that input file using the macro. Please let me know if you have any questions before submitting a proposal. Thank you!
Project ID: 8138407

About the project

38 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 there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$22 USD in 0 day
5.0 (265 reviews)
6.7
6.7
38 freelancers are bidding on average $38 USD for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). Please, share the files
$59 USD in 4 days
5.0 (673 reviews)
8.7
8.7
User Avatar
A proposal has not yet been provided
$100 USD in 0 day
4.9 (339 reviews)
7.7
7.7
User Avatar
Dear client, I can accomplish the job for you. I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
$30 USD in 2 days
5.0 (502 reviews)
7.8
7.8
User Avatar
Hello! I work with VBA for last 5 years, and have created hundreds of different scripts, including .csv scrapers. I will provide You excel file with script, so U will need to open it, press button, choose csv file, and macro will do the rest. If You need somebody who really can manage difficult things, the choose me, i am not indian who has hundreds of 10 usd projects, and deliver recorded macro. I will create script from the scratch, that will have best performance and 100 % accuracy. Hope for Your respond, Regards, Vlad
$55 USD in 1 day
5.0 (67 reviews)
7.7
7.7
User Avatar
A proposal has not yet been provided
$75 USD in 1 day
4.9 (260 reviews)
7.7
7.7
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
$66 USD in 3 days
5.0 (339 reviews)
7.5
7.5
User Avatar
Hi Sir. I have gone through the files and project description and it is very much manageable. I am well versed in VBA Excel and I can do the job in 1 day. Please discuss so we may continue. Thank you. Usman
$80 USD in 1 day
5.0 (95 reviews)
7.1
7.1
User Avatar
Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaza. The attached image is screen shot for Add-in for Excel to integrate Excel with another application called MetaTrader4 to allow the users to trade from within Excel. This project is complicated and deal with many technologies and fields like calling underlying layer for communications and graphics to have dynamic charts and link to MS Access to store the actions by the user and finally controlling MetaTrader from Excel. I am ready to discuss and doing your project. Regards, Eyad
$111 USD in 2 days
5.0 (33 reviews)
7.2
7.2
User Avatar
Hey, I read through the description and saw the files as well. I can write a script in excel that will generate the two files from the input data on click of a button. I can deliver this macro in a day and get started as soon as the bid is accepted. I am an expert in excel macros as you would see in my work history here on freelancer and can assure you of excellent quality work. Drop a note to me and we could get started right away. Thanks and Regards, Rishi
$40 USD in 1 day
4.9 (125 reviews)
6.6
6.6
User Avatar
Experience on Dhaka Stock Exchange Ltd. for 10 year on Windows Back Office for their dealer accounts to maintain financial and securities accounts. I have two real time Windows and Web application is using near about 50 companies in Bangladesh. Experience on VB,VB.NET,ASP.NET,WPF and MS-SQL 2008 for 10 to 15 years. I have experience in converting codes from C#,C++,JS to VB or VB.NET and MySQL to MS-SQL 2008 R2
$10 USD in 1 day
5.0 (17 reviews)
6.3
6.3
User Avatar
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 250 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD in 5 days
4.9 (126 reviews)
6.4
6.4
User Avatar
hey there... we can do excel macros... the attachments are not available... please provide... thank you...
$29 USD in 1 day
4.8 (207 reviews)
6.1
6.1
User Avatar
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. 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 in 1 day
4.9 (64 reviews)
5.7
5.7
User Avatar
Hello. I have great experience with VBA macro. I could to do this work good and fast .
$35 USD in 3 days
5.0 (48 reviews)
5.8
5.8
User Avatar
Hello, I have been working with a MNC based company since last ~ 4.5 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$35 USD in 1 day
4.9 (66 reviews)
5.6
5.6
User Avatar
La propuesta todavía no ha sido proveída
$45 USD in 3 days
4.8 (12 reviews)
4.5
4.5
User Avatar
I am bidding low just to create a good working relationship. The task is simple but the size of the input file is very large, It might take 20-30 mins to completely to divide a single input file.
$10 USD in 2 days
5.0 (23 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
$105 USD in 1 day
4.6 (14 reviews)
4.2
4.2
User Avatar
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. I have over 15 years of experience as Physics and Math teacher; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access and VBS tinkering. I am proficient in making Templates and Macros and conditional formatting, etc. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
$30 USD in 1 day
5.0 (20 reviews)
4.0
4.0
User Avatar
Finished a similar project earlier also. Let me know if my experience and services can be available for your help.
$15 USD in 1 day
5.0 (9 reviews)
3.6
3.6

About the client

Flag of UNITED STATES
Palo Alto, United States
5.0
33
Payment method verified
Member since Jan 27, 2015

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.