Macro to split cell data into rows and copying other cells

Hi guys,

Unfortunately I am too new to VBA and don't really have experience with it, but need to finish this task asap Your assistance is greatly appreciated.

I have excel file with product descriptions and attributes.

Attributes are separated by comma, i.e. color black,red,blue, etc..
also i have a size attribute, i.e. small, large, etc.

What I am trying to do is to create a new worksheet, which will contain
product1 name, size, color, data1,data2, data (n) fields.
product2 name, size, color, data1,data2, data (n) fields.

I can extract parameters, separated by delimiter, but its not copying remaining data fields for the product.


Attached is my excel file with the macros inside, data-template-v1.0 (its macros enabled)
and also data-template.v1.0-nomacros.xls ( actual macros is inside on first page)




Any help will be greatly appreciate it.

Thanks!

'ROWS TO COLUMNS
I have a macro that may be "ready to use" for expanding rows of data to multiple rows parsing out the values in one column while duplicating all the others.

Rows to Columns - Part 2

Just edit the Col = 2 code to the column you need to expand and run the macro on a copy of your data.

Then run it a second time with Col = 3 on the results of the first run, and you're done.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.