stefanaalten
Board Regular
- Joined
- Feb 1, 2011
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
On my source data worksheet I have many links to images (all held locally on my hard drive). Each row represents a film and each row may contain a single image, inserted as a link (Excel 2007, Insert > Picture > Insert - Link to file). I have "snap to grid" switched on - the image sits nicely between the row lines, in the final column of each row.
I would like to display the same images on a separate worksheet. The order of the rows on this worksheet may differ from that on the source data. I would also like to display the image in a larger size.
For example, on sheet1, the image is in cell AE32 and 30x50 pixels. On sheet2 it should be displayed in cell I114, and sized to 50x80 pixels.
The next image on sheet1 is in AE33 and should be displayed in I125, etc.
I have a simple formula to convert the rows from sheet1 to sheet2.
How can I insert a reference to an image and control its size (scaling up)?
I would like to display the same images on a separate worksheet. The order of the rows on this worksheet may differ from that on the source data. I would also like to display the image in a larger size.
For example, on sheet1, the image is in cell AE32 and 30x50 pixels. On sheet2 it should be displayed in cell I114, and sized to 50x80 pixels.
The next image on sheet1 is in AE33 and should be displayed in I125, etc.
I have a simple formula to convert the rows from sheet1 to sheet2.
How can I insert a reference to an image and control its size (scaling up)?
Last edited:
