Forum Discussion
Image file as value
Hello Rmart911,
images in Excel don't actually sit inside a cell. They are graphics objects that are in a layer on top of the grid, like a transparent sheet laid over the Excel sheet.
What you describe is not possible with just worksheet formulas. It would require some serious VBA programming.
If you create the workbook from scratch, you could place the image in a sheet and use that as a template sheet. When you want to add a sheet, copy the template sheet.
I've seen some tutorials that have images embedded in the sheets somehow so that if a value in a cell (A1) is 'orange' for example, a picture of an orange would show up in A2. If A1 'banana', a banana, etc.
It seems to me that if that can be done there should be a way to do what I'm looking for. Would be useful.
- If you need a picture lookup, you may refer to this link:
https://www.computergaga.com/blog/create-a-picture-lookup-in-excel/TwifooThat looks very useful and I'm going to bookmark that page. Thank you. It's more complicated than I need though. I just want to drop an image in a cell on the first sheet and have it show up in the corresponding cells on a dozen other sheets.
The image file is provided by clients at infrequent intervals and having to embed each image file into a separate index is too complicated for most of the people who will be using it.
Right now we need to place the image in a cell, copy that cell, and paste it into each of the other sheets manually. I'd just like to streamline that step without having to be the goto person to embed each new image into the worksheet.
Rmart911 The technique you describe is done with a dynamic image that changes its content based on a formula. It is not a new image every time, just what the already positioned and sized image displays will be changing.
