Copy images from one worksheet to another depending on matching cell value in row.

Hi,

I am trying to copy images from one worksheet (master worksheet with all data and images) if a cell value matches and place onto a separate worksheet with select rows on it. I've watched this tutorial: http://www.youtube.com/watch?v=P4XriuikOs8, but it only shows how to do it in one cell rather than a whole column.

Essentially if the figure in column A matches in the second worksheet, I want the row data to be duplicated including the image.

For the copied data from the master worksheet to another, I used VLOOKUP and it works great but obviously that won't work with images.

Is there a way to do this?

Regards,
David

Hi,

Thanks for the reply.

I've attached the spreadsheet this time so hopefully you can understand my problem.

As you can see, I've used VLOOKUP in the second worksheet (loan template) to copy over info from the main worksheet if the content in the first column matched. This worked fine. However, I want to be able to do the same for the images in the 'indicative image' column and have them transferred over also.

Is there a way to do this? Does it require VBA?

Thank you!