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


--
sweetboo22
------------------------------------------------------------------------
sweetboo22's Profile: http://www.excelforum.com/member.php...o&userid=37413
View this thread: http://www.excelforum.com/showthread...hreadid=571162