Ditutup

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

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

Kemahiran: Visual Basic

Lihat lagi: visual basic expert 2008, visual basic expert, want visual basic expert, expert visual basic, visual basic expert job, projects time table management class staff visual basic, programmer needed reverse compile visual basic exe file, pda expert visual basic exemple, expert visual basic romania, copy multiple columns excel macro visual basic, want hire visual basic expert, convertire visual basic excell visual basic, convert excel visual basic file visual basic, metatrader build basic expert advisor, software expert visual basic mumbai list

Tentang Majikan:
( 170 ulasan ) Faridabad, India

ID Projek: #11941926

49 pekerja bebas membida secara purata $104 untuk pekerjaan ini

$100 AUD dalam sehari
(114 Ulasan)
7.1
avinav606lx

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 quali Lagi

$66 AUD dalam 0 hari
(62 Ulasan)
5.7
MohsanEijaz

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 perfe Lagi

$155 AUD dalam 3 hari
(25 Ulasan)
5.1
abhinovpankaj

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 vari Lagi

$111 AUD dalam 3 hari
(32 Ulasan)
4.9
TonmoyRoy111

A proposal has not yet been provided

$100 AUD dalam 2 hari
(34 Ulasan)
4.5
$50 AUD dalam 3 hari
(14 Ulasan)
4.5
cugamelover

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, f Lagi

$80 AUD dalam sehari
(25 Ulasan)
5.2
liangjongai

<<Hi! I'm interesting your project very well. I am mastering cvband I'm a good Mathematician. And also I have many experience and good skill about web and android development. Let's go ahead with me >>

$100 AUD dalam sehari
(4 Ulasan)
3.7
lxqcad

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 Lagi

$80 AUD dalam sehari
(5 Ulasan)
4.0
axiomswb

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 dalam sehari
(7 Ulasan)
3.4
fb57e1f6608abfb

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 de Lagi

$66 AUD dalam 0 hari
(2 Ulasan)
3.1
rohitagarberg

hi sir, i will create the visual basic exe for these csv operations. thanks....................................................

$30 AUD dalam sehari
(12 Ulasan)
3.2
vivirain

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 dalam 3 hari
(4 Ulasan)
2.9
$155 AUD dalam 10 hari
(5 Ulasan)
2.7
benbuyum

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 dalam 5 hari
(2 Ulasan)
2.8
Goalaholic

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 dalam sehari
(2 Ulasan)
2.3
vw7918031vw

systems Engineer with 10 years of experience in the administration and development of systems for multinationals with experience in C C ++ C # VB ASP .NET

$50 AUD dalam sehari
(4 Ulasan)
2.3
Evgene

Contact me (before accepting my offer if you want) and I will make a brief prototype and show you how it works on video. If you will accept my proposal, I think it can be done in the following way. The script will wo Lagi

$250 AUD dalam 7 hari
(1 Ulasan)
1.9
$30 AUD dalam 0 hari
(0 Ulasan)
0.0
sasapetrovicfalc

Well, I can do that with some Excel Macro script and maybe with little modification of that macro in VBA. It will be simply to do for any latter documents in future. I will also share that with you. Well, I can do th Lagi

$55 AUD dalam 3 hari
(0 Ulasan)
0.0