Need VBA expert to convert my Excel files

Budget

$137.93FIXED

Client

Hemlata GkIndia

Status

ClosedNov 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

Custom Excel Spreadshet VBA - Task...

Create a custom spreadsheet that will be used for task & project management.

Project tasks broken up into several categories with each category containing take and sub tasks.

Each ta...read more

Fixed, $18.00

Expert in Calculation of IRR and P...

Looking for a Freelance with good understanding of IRR and Preferred rate of return calculations. This is in relation to the calculation of performance fees for a Fund . I have a calculation made up...read more

Fixed, $22.00

Convert MS Word and PDF to PAGES

I have 1600 of MS word and PDF files that I want to convert in .pages. I need a specific formatting and to remove a few picture from them, but it's basically a lot of copy and paste.

Fixed, $400.00

Internet Research: Data Entry / Exc...

I am looking for someone with great research skills, who is focused and has experience building lists.I have PDF files for each details. I am looking to build a list of all the independent and chai...read more

Fixed, $360.00

Microsoft Office Improvements

We are looking for someone to meet the requirements shown in the Word Document which spells out the improvements we are looking to make in our current microsoft access database. (Doc will be provided...read more

Fixed, $100.00

Here are our top professional picks for you to hire

Member Technical
VBA 
$5 /hr
India
Computers and math teacher
C Programming Mathematics Excel 
$12 /hr
United States
Java Developer
Data Entry MS Office Excel 
$0 /hr
India
Sr Analyst
Tableau Software VBA Excel 
$25 /hr
India
Tableau Developer
Tableau Software Data Visualization Data Science & Analytics 
$4 /hr
India
DW/ETL/BI
Informatica "Extract, Transform and Load (ETL)" SQL Server Integration Services (SSIS) 
$33 /hr
India
Re-creator & Modifier
Google Docs Excel Computer Networking 
$10 /hr
India
Web Business Systems Builder
Web Hosting PHP javascript 
$55 /hr
United States
sql Microsoft Excel VBA 
/hr
India
To view more profile join Toogit

Get Started