Need VBA expert to convert my Excel files

Budget

$137.93FIXED

Client

Hemlata GkIndia

Status

AwardedNov 28, 2017
Convert Flat Excel Worsheet into a specific format

Need to convert excel worksheet with product table into a specific format contains product attribute and variants. The output file format can be in Excel or CSV.

Product attributes: Size, Color1, Color2
Product Size variant: X, M, L, XL, ..etc
Product Size colors: Blue, Black, Red, etc

Every product has a unique code containing the type, size, and colors.
Product size in encoded with 1 digit of code.
Product colors in encoded with 1 or 2 digits of code.

Sheet1 = original workseet
Sheet2 = target worksheet

First, sort the Excel worksheet by Column D ascending.

Explanation on the target worksheet:

Col A:
sequence containing string "product1", "product2", etc

Col B:
value is taken from Sheet1 column D. If for the first row that the values are the same accross rows.

Col C:
value is taken from Sheet1 col S

Col D:
static string "product"

Col D:
value taken from Sheet1 col G

Col F:
value taken from Sheet1 col I

Col G:
value taken from Sheet1 col L

Col H:
value taken from Sheet1 col M

Col I:
value taken from Sheet1 col N

Col J:
value taken from Sheet1 col O

Col K:
value taken from Sheet1 col C up to the next different product at col B

Col L:
concatenate of "size" + substring(13,1) of column B + ",color" + substring(14,2) of column B

Col M:
value taken from Sheet1 col E

Col N:
value taken from Sheet1 col F

Col O:
new row with static string "attribute_size"
new row with static string "attribute_color"
or "attribute_color2" when the color code is 2 digits eg. substring(14,2) of column B is 2 digits length

Col P:
at row "attribute_size" : concatenate all "size*" at Col L
at row "attribute_color" or "attribute_color2": concatenate all "color*" at Col L

Skills & Expertise Required

VBA Excel 

Project closed for bidding!



Share this project with your friends



Similar Projects

Development of underwriting Process...

We are looking for someone to help with the underwriting and due diligence process for a distressed asset Investment vehicle.

We buy Non Performing Residential Mortgages, and are now wo...read more

Hourly, $27.00

Create a vb script to connect, get...

i need a vb script that will connect to zoho creator using REST API to connect to my application on zoho creator using api key and query and post data to the application

Fixed, $34.48

Trade Automation calculating Implie...

I need you implement a trading strategy on Zerodha Kite/Upstox Pro trading platform(Api & documentation available on their website). Basically to automate my trades by finding Implied volatility o...read more

Fixed, $172.41

Hiring skip tracer *Must have acces...

Looking for experienced skip tracer for long term partnership. You must have your own access to LexisNexis or TLO!!

1. Ability to gather contact info (Phone number primarily) after give...read more

Fixed, $51.75

Googe Names and Find Information

We have the names and email address of 35168 people that are most likely in software field. We need a data collector to

1) google their name
2) find their mobile no
3) fi...read more

Fixed, $86.21

Here are our top professional picks for you to hire

Professional Writer and Web Developer
Data Entry Research Content Writing 
$3 /hr
Kenya
Business Development (New Client Acquisition)
Lead Generation Market Research Analytics 
$5 /hr
India
Reporting Analyst & VBA Developer
Excel VBA Microsoft Excel Excel 
$5 /hr
India
Virtual Assistant
Administrative Support Social Media Marketing Excel 
$2 /hr
India
Operations Manager
Excel Microsoft Powerpoint Photoshop 
$5 /hr
India
Virtual Assistant
Link Building Photo Editing Data Entry 
$3 /hr
Philippines
Research Analyst
Excel Data Processing Lead Generation 
$10 /hr
India
data analyst
Word Excel Windows 
$0 /hr
India
Data Entry Operator
Data Entry SMS Email Handling 
$15 /hr
Saudi Arabia
To view more profile join Toogit

Get Started