Hi I don't know if this could be done but it doesn't hurt to ask.
I have 2 sheets of data. One sheet has a list of products. The other sheet has the correlating pictures for the products. Some have 2 pictures some have 5 pictures and so on. I want to move the pictures beside the product name in a new column. The pictures have part of the product name in it making it easy to know which product it goes to. It is just time consuming to count how many images there are an then insert the rows.
Is there anyway this can be done? I am familiar with vba I just don't know how to write codes.
Example:
Sheet 1
Shoes
Dress
Bottom
Shirt
Sheet 2
Shoeimage1
Shoeimage2
Dressimage1
Dressimage2
Dressimage3
I want it to look like:
Column AColumn BShoesShoesimage1Shoesimage2DressDressimage1Dressimage2Dressimage3
Thank you in advance.
Bookmarks