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
3 freelancers are bidding on average $43 for this job
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