Find Jobs
Hire Freelancers

Visual basic expert Needed for multiple projects. - 31/10/2016 09:02 EDT

$30-250 AUD

Closed
Posted about 7 years ago

$30-250 AUD

Paid on delivery
I have a set of approx 90 standardized excel files (in .csv format), which all need to be manipulated the same way. I need a script that I can run as I get more of the same files over time. This is what it needs to do (some details removed, will be delivered upon starting the assignment): Step 1: Delete columns a&b&d&h&j&p&q Step 2: Insert 4 columns before column A Step 3: add the following Column Headers in Row 1: Field A1 = Field B1 = Field C1 = Field D1 = Field E1 = Step 4: Insert 7 columns between columns E and F Step 5: add the following Column Headers in Row 1: Field F1 = Field G1 = Field H1 = Field I1 = Field J1 = Field K1 = Field L1 = Field M1 = Step 6: Remove the "X" throughout column M Step 7: Move the first cipher from Column M to Column L. Step 8: add the following Column Headers in Row 1: Field N1 = Field O1 = Field P1 = Field Q1 = Field R1 = Field S1 = Field T1 = Field U1 = Field V1 = Field W1 = Step 9: The text in Column N needs to be abbreviated according to the following rules: Step 10: Column I must match column E, but all space must be exchange for -'s. Step 11: Save as .csv and return
Project ID: 11941926

About the project

42 proposals
Remote project
Active 6 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
42 freelancers are bidding on average $100 AUD for this job
User Avatar
A proposal has not yet been provided
$100 AUD in 2 days
5.0 (179 reviews)
6.8
6.8
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$66 AUD in 0 day
4.9 (80 reviews)
5.9
5.9
User Avatar
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$155 AUD in 3 days
5.0 (44 reviews)
5.9
5.9
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC 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 and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- 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
$111 AUD in 3 days
4.8 (46 reviews)
5.2
5.2
User Avatar
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..
$50 AUD in 1 day
5.0 (10 reviews)
4.8
4.8
User Avatar
hi sir, i will create the visual basic exe for these csv operations. thanks....................................................
$30 AUD in 1 day
5.0 (61 reviews)
4.9
4.9
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$80 AUD in 1 day
4.2 (25 reviews)
5.4
5.4
User Avatar
Thanks for the detailed description. It helps in quoting the right amount for the job. If you send me the excel file now along with the missing details, you can expect a quick turnaround of less than 5 hours to get the resulting excel module with the vb macro ready for your use.
$80 AUD in 1 day
4.7 (11 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$100 AUD in 1 day
5.0 (1 review)
3.8
3.8
User Avatar
Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint, QlikView based tools/processes, reports. I can assure you of high quality and on-time deliverable from my side as that is the sole criteria to work and deliver. Hope to hear back from you soon :) #CustomerFirst Best Regards, Rohit Ahuja
$66 AUD in 0 day
5.0 (2 reviews)
3.1
3.1
User Avatar
Hi there, I'm interested in the job and can help get it done quickly as required. Feel free to contact me and discuss more details. Best Regards, VL
$60 AUD in 3 days
5.0 (6 reviews)
3.2
3.2
User Avatar
Your brief is clear. I will build a script in VBA to do this. It will be perfect if you could just attach a sample file, one of your csv's.
$122 AUD in 5 days
4.9 (2 reviews)
2.8
2.8
User Avatar
I have 5 years of experience with VBA Excel. I have vast experience working with CSV. I can do this job instantly. Kindly share the files. Looking for your response.
$83 AUD in 1 day
5.0 (2 reviews)
2.3
2.3
User Avatar
Having two+ year experience in data management in excel using lots of vb scripts. I believe I can make/ reformat your vb scripts to fulfill your requirement.
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good knowledge in Excel programming. Had completed 'n' number of projects. I am sure, I can complete this project within 7 days
$222 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done so many projects like this in my company Vodafone...
$66 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Client I saw your outline. I understood your need. It would be good for you to send me your requirement more detail. Contact me and we can get started right away
$55 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a VBA development software for Excel and Access company
$133 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
One of my long term clients often provides me with a zip file containing hundreds of Excel files, which require data extraction and consolidation on a common Excel based platform. I see many similarities to the work you are requesting and feel this would be an project I am well suited for. I prefer an hourly contract, and am interested in an ongoing relationship. Mike! (Canada)
$130 AUD in 5 days
0.0 (0 reviews)
1.0
1.0
User Avatar
Hello, I work as Developer and I have a lot of experience with visualBasic and macros. If you are not decided yet we can make some conference on skype and talk about it. In my company I have created a lot of macros which improve daily work in all departments. BR Piotr
$72 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Faridabad, India
4.9
720
Member since Feb 21, 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.