Find Jobs
Hire Freelancers

Write a script for Excel 2016

€8-30 EUR

Completed
Posted over 7 years ago

€8-30 EUR

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: 11941868

About the project

7 proposals
Remote project
Active 7 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 help you. I've done hundreds of excel projects (with both formulas and macros, where i convert/modify one format to another one) and i've never had a single problem. If you are interested please send me a sample sheet so i can take a look at what exactly needs to be done (nothing is attached in project description). As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan
€30 EUR in 1 day
5.0 (172 reviews)
5.8
5.8
7 freelancers are bidding on average €31 EUR for this job
User Avatar
Dear client, 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
€24 EUR in 1 day
4.8 (123 reviews)
5.6
5.6
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€28 EUR in 1 day
4.9 (58 reviews)
5.1
5.1
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 6 years of experience. I have successfully completed few projects for US clients which involved web scraping, web research,internet research and data entry. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
€20 EUR in 1 day
4.7 (16 reviews)
3.4
3.4
User Avatar
Hello Sir, We are a team of more than 20 people and been in software industry for more than 10 years having experienced candidates in Android, IOS, VBA, MACRO, JavaSe, JavaEe, MySQL, SQL. SHORT DESCRIPTION: First we will discuss final requirement. We will keep on sending you beta versions for design review and functionality testing We will send final version of application along with code after your 100% satisfaction with beta versions You can release the milestone after you get your work COMMITMENTS: o 100% requirement fulfilment. o Unlimited revisions/changes are allow until you will be 100% satisfy. OUT OF THE BOX: 3 months free full application support. Note: Exact time and cost will be decided after complete requirement Thank you for your consideration. Have a great time.
€35 EUR in 2 days
5.0 (2 reviews)
1.9
1.9
User Avatar
Hi, Being attracted with your declaration of program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind-mind and as soon as possible. Sincerely Yours obedient helpful person
€23 EUR in 1 day
5.0 (2 reviews)
0.0
0.0

About the client

Flag of DENMARK
Hellerup, Denmark
5.0
1
Payment method verified
Member since Jan 29, 2016

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.