Copy photo from one a Excel to another based on common key

Any idea how to copy picture from one file to another based on the a common key ?
Who is Participating?
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
If the photos are embedded in the Excel file like this:
examplethen you won't be able to link to them.  Even linking to the associated cell will produce no results.

If the photos had the ID value in their filename somewhere, you might be able to create a link to that file and have the image displayed.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Lots of ideas. Just no idea what you are talking about.
AXISHKAuthor Commented:
Excel 1
ID                  photo
123               photo1
356               photo2
ATF               photo3
901               photo4

Excel 2
ID                  Price          Photo [link to here]
901               56.7            
123               12.7
ATF               9.78
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
I think you need to provide an example spreadsheet, because whilst I am slightly clearer, I don't know in what format you currently have the information.
AXISHKAuthor Commented:
All Courses

From novice to tech pro — start learning today.