Display Image or Picture From Another Worksheet
How to Display an Image from Another Worksheet based on the Criteria Value or Text Condition From Drop Down Menu in the Cell
In this tutorial I will show how we can on the worksheet in Excel to display a certain image or picture that you can choose from the drop down menu whether the image (picture) name or code or number value. This is a simple Excel example of a picture in the adjacent cell (or any cell) to another sheet based on the condition that there is a cell in another worksheet that there is a drop down menu or directly write the image name, number and the like as well as this condition can be obtained by a formula. There are many situations where this example can be used and it all depends on the needs of users of Excel.
In the tutorials in which I have already written about insert images from a folder and adjusting the size of a cell or display picture from the same worksheet. You can see similar actions as the previous step of this tutorial.
In the picture below you see Sheet1 where in the cell 'A1' is the name of the image (number, code, etc.). In 'B2' cell we want to display the picture from another worksheet to which it belongs name from the cell 'A1'. Here I used a cell 'B2' but this is irrelevant. You can use any cell in the Excel worksheet.
In the picture below you see Sheet2 which appears in 'A' column list of all images with their names (or codes, numbers, etc.). In the 'B' column are inserted all the images in the classical way (Insert => Pictures). Therefore, the data are in the 'A2:B8' range.
When we have prepared the form of a worksheet go to the next step in order to 'Sheet1', display an image from 'Sheet2', so my choice is made with the drop-down menu.
Necessary is to Excel Name Manager naming by the name of some formulas and cells. So click on the tab Formulas => Name Manager command and name the following formula. (see image below to create a new name in the Name Manager)
Refers to: =OFFSET(Sheet2!$A$2;;;COUNTA(Sheet2!$A1:$A8);1)
Refers to: =OFFSET(Sheet2!$B$2;MATCH(DropDown;ChangingPictures;0)-1;0)
The next step is to naming a cell 'A1'. So, select the 'A1' cell and in the 'Name Box' type 'DropDown'. (see image below).
And finally a look at Excel Name Manager looks like as shown below.
All previous actions we have provided the necessary conditions for image display on 'Sheet1'.
Furthermore it is necessary to 'Sheet2' select 'B2' cell (which contain the first picture)
ATTENTION !!! Do not select the image, select the cell in which the first image. Well, then Copy from the Ribbon Tab.
Position the cursor on Sheet1 and select 'B2' cell in which the need to display an image. (here are accidentally identical addresses but do not you think that it must be so).
On the Home tab, click Paste and choose the Linked Picture (I) command. (see image below).
Now, we have a situation where the image (picture) will appear on Sheet1 and when selecting an image (picture) you see in the formula field, the following formula =Sheet2!$B$,
Delete this formula and type =Pictures.
Data Validation - Choose Image from List
Finally, the last action is to create a list of images in a 'A1' cell by the Data Validation. So select the 'A1' cell then click on the tab Data => Data Validation, select List, and type in the field Source: ChangingPictures.
Finally, the result of this tutorial is to Display the a Image or Picture from another Worksheet based on selection from the Drop Down Menu.
Also, see another tutorials for Display Image/Picture