would love help creating a macro to insert information

[sweetboo22]

Ok, hope I explain this well enough. I have rows of inventory in excel
and need to add child rows under the parent rows.

For example.. I have a row with the parent information : sku, title,
etc
then under it I have to have the sku plus the pertaining information
such as large, xl, med, etc in the colum with the sku. then in the
title column the rows have to have the same information added to the
title

sku product-name size
1-tshirt I love my MOM T-shirt
1-tshirt-sm I love my MOM T-shirt Small Small
1-tshirt-md I love my MOM T-shirt Medium Medium
1-tshirt-lg I love my MOM T-shirt Large Large
1-tshirt-xl I love my MOM T-shirt XL X-Large
1-tshirt-2X I love my MOM T-shirt 2X XX-Large
1-tshirt-3X I love my MOM T-shirt 3X XXX-Large
1-tshirt-4X I love my MOM T-shirt 4X XXXX-Large
1-tshirt-5X I love my MOM T-shirt 5x XXXXX-Large


Is there a way to do a macro for something like this? I have thousands
of inventory and various types of media besides shirts. so any help
will be greatly appreciated.
Brenda

 

[mrice]

Are you saying that the data is currently all in the same column and you
want to split it out into three adjacent columns?

 

[sweetboo22]

I don't think I explained myself correctly. I apologize, I have
thousands of pieces of inventory and for me to upload them into my
store online, I have to put the name ex: I love my MOM tshirt as a
parent line, then under it, there need to be 'children' lines that
correspond to the parent line but they specify the size. So, for each
parent line, there will be 8 child lines that designate if it is a
small, med, etc. so there are 3 columns this will affect.
I am wondering if there is a way to do this with some kind of macro?
If not, I will have to paste and find and replace for each parent line.
I am just not sure how to do it. I have taken an example and
highlighted the parent lines and showed how the children lines need to
be set up on the first two.
Thanks
Brenda

http://us.a2.yahoofs.com/users/44b6ebe7zb8156a1e/fa56scd/__sr_/336cre2.jpg?phQlJ4EBXsEMBJzC

 

[Earl Kiosterud]

Brenda,

I think you're going to have trouble down the road with the layout you're
using. You will be much better off with a standard database-style table.
There should be one record (row) for each piece. No parent/child stuff. It
might look like this

I love my mom S
I love my mom M
I love my mom L

All the necessary information to describe each item is in its row. This may
seem like more trouble, but believe me, you'll be glad you did it this way
later.