Forum Discussion
Dynamic Image with Hyperlink
How to insert image or picture dynamically in cell based on cell value in Excel?
none Microsoft site
In many cases, you may need to insert image dynamically in cell based on cell value. For example, you want the corresponding images to be dynamically changed with the different values you entering in a specified cell. This upper link will show you how to achieve it.
Otherwise, I would strongly recommend VBA, since the possibilities are more extensive than with any formula.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
How to insert image or picture dynamically in cell based on cell value in Excel?
none Microsoft site
In many cases, you may need to insert image dynamically in cell based on cell value. For example, you want the corresponding images to be dynamically changed with the different values you entering in a specified cell. This upper link will show you how to achieve it.
Otherwise, I would strongly recommend VBA, since the possibilities are more extensive than with any formula.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
- Hi Nikolino,
Thanks for the response, I've used this method before, in this case I wanted the image's to maintain different hyperlinks. Reading up on this, it would seem that this is not possible, to get around this I've added a VLookup combined with the Hyperlink function below the image, that way the Hyperlink changes based on the referenced cell value and can be directly clicked to follow the hyperlink path.
Regards
Newbeetle- Thank you for your feedback.
I wish you continued success with Excel :).
