Completado

Write a script for Excel 2016

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

Habilidades: Procesamiento de datos, Excel

Ver más: linux script write txt excel, perl script write data excel file, perl script write text file excel, agi script write data text file, filemaker script write text file, importing text file excel script, excel script import text file, adding find text function excel script, autocad script write text, macro reading excel file write text file, script write excel mysql php, perl script write text file, write results query text file visual basic script, excel marco write unicode text, import text excel script, excel script generate text files cells, perl script write text, excel script database connection, vba excel script, excel script copy cell data closed file

Información del empleador:
( 1 comentario ) Hellerup, Denmark

Nº del proyecto: #11941868

Adjudicado a:

MimiFL

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 h Más

€30 EUR en 1 día
(172 comentarios)
5.8

7 freelancers están ofertando el promedio de €31 para este trabajo

€55 EUR en 1 día
(49 comentarios)
5.2
TonmoyRoy111

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 detail Más

€24 EUR en 1 día
(123 comentarios)
5.6
schoudhary1553

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 ex Más

€28 EUR en 1 día
(58 comentarios)
5.1
narsim3128

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 sc Más

€20 EUR en 1 día
(16 comentarios)
3.4
freemanish

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: Firs Más

€35 EUR en 2 días
(2 comentarios)
1.9
ChinmoySarker

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. S Más

€23 EUR en 1 día
(2 comentarios)
0.0