Transfer pictures from one workbook to another

Contributor

I would like to build two workbooks. Workbook A contains a list of animals and pictures as raw data; Workbook B contains a list of animals, and could automatically get their corresponding pictures from Workbook A.

 

If they were numbers or texts rather than pictures, we could connect the two workbooks by external links (to ranges or names), or by Power Query. But it seems that external links or Power Query don't work with pictures?

 

Does anyone know how connect two workbooks to achieve this? Does anyone know if it is possible to assign a picture to a cell?

 

Screenshot 2021-11-20 at 17.00.11.png

 

0 Replies