Sorting images to the respective SKU

I have a list of products in a Master file and I want to fill only the following on another worksheet

title
description
image1
image2
image3
item_specifics (SKU)

Please note that each SKU will have more than 1 image(s). I want to put the 1st image of that respective SKU to image1 and 2nd image of that respective SKU to image2 and 3rd image of that respective SKU to image3. After filling the 1st 3 images, automatically the file should pick the 2nd SKU in the Master file to repeat the same process for the 2nd SKU.

Please help me to fix this.

Anyone out there please?

Hello... Nobody is here? Please help me

Originally Posted by FlameRetired

This is a challenging puzzle.

Additionally response may be a bit slow for a few days.

If you are not aware of it the United States is approaching a major holiday.

Of course while not every contributor is American it may have a noticeable affect.


Before attempting a solution I have a few questions.

1. I assume the "title" is in column D? - Yes
2. If there is no "description" what do you want returned in the second row of each set?
   
3. Do you want to return all of the numbered jpgs in each set or just the first 3? - Just the first 3 or even any 3 pictures are fine
4. Are there any additional criteria? - I have mentioned everything below
5. Is there any additional output you'll want? - I have mentioned everything below

Firstly, I thank you for responding to my query and appreciate your support. Secondly, I have forgotten to upload the

required Excel sheet to be filled. I have uploaded only the Master sheet but not "bulk_upload_sample.xlsx". Please refer

the Excel sheet which needs to be filled and it's name is "bulk_upload_sample.xlsx"

I want to fill only the column B, F, J, K, L & M in "bulk_upload_sample.xlsx"

Originally Posted by FlameRetired

Does it have to be separate workbooks. ie can I just copy the sheet with the data and paste in a new sheet of bulk_upload?

I want with forumulas not just the answer so that I can do on my own for other products. If you want, you can do this. Prepare 1 Excel file. In that, you can have Master sheet with all the data I have uploaded and formula sheet with filled columns