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
There are 3 columns above, but I don't know how to make them align like they look in excel
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
Bookmarks