Em Andamento

Custom Macro To Edit CSV FIle

I require an highly qualified script writer to write a custom macro to edit a large csv file automatically.

It should a very easy and quick job for an experienced writer.

The script must automatically.

- merge/regenerate/remap products category columns to my specifications.

- rename and re-order columns.

- delete specific columns

- apply pricing formulas to specific categories

The script writer must also be able to train me to change price and category variables in the macro.

The script writer must be able to made adjustments as required.

I will supply the file I need editing and the desired output.

Here is want needs to be done specifically.

1 Transfer Title Column to a new column called “Name” to be located at A position
2 Transfer UnitPrice Column to a new column called “Buy Price ex GST” located at I position
3 Transfer RRP Column to a new Column called “Recommended Price” located at K position
4 Transfer Manufacturer Code to a new column called “SKU” Located at B position
5 Call every row with Inks/Toners/Drum and transfer to Column Category 1 (Inks & Toners) located at D Position
6 Transfer HTML Description Column to a new Column called Description locateed at C Position
7 Transfer Image URL Column to a new Column called “Image URL” located at G Position
8 Create A Colunm called Category 2 at E Position
9 Create A Colunm called Category 3 at F Position
10 Create A Column Called Weight at Position H
11 Create A column called Price at Position J that can call a formula specific to Column Category 1
12 Create A Column Called Quantity At Position L
13 Create A Column Called Enabled and call the value yes for each row



Habilidades: Excel, Javascript, Python

Ver mais: order custom javascript, job script writer, i need javascript writer, custom formulas in excel, need to edit, csv file, edit macro, macro script file, write macro, csv merge, excel macro csv, excel required csv, javascript write excel, merge javascript, excel 2013 macro, write file excel, edit macro excel, edit output, excel edit, excel custom, edit products, write file macro excel, excel products categories, EDIT EXCEL, excel pricing macro

Acerca do Empregador:
( 6 comentários ) Alpha, Australia

ID do Projeto: #5145912

Premiar a:

deepbluetech

Hi PeterGerard73, Had a look at the input / output files and I can take on the job. Shall provide Excel macro script to meet your requirement within a day. Shall also provide additional instructions to change pri Mais

$50 AUD em 1 dia
(79 Avaliações)
5.4

3 freelancers estão ofertando em média $43 para este trabalho

imoran21

this is what i do for a living. I have written my own python modules for csv handling. I work professionally in financial data processing of millions of record. After seeing your update I am confident I can have thi Mais

$55 AUD in 3 dias
(2 Comentários)
3.2
shanondollar

Hello buddy! Could you send the file asap? I would like to start work immediately. Don't worry.. my VBA macro can be customized right from the excel sheet

$25 AUD in 3 dias
(0 Comentários)
0.0