You want to display a picture in Sheet 1, cell B40 that is located in Sheet 2, cell A1?
If I understand it correctly…
Here are the steps to achieve this in Excel:
1. Insert the picture that you want to display in Sheet 2, cell A1. To do this, click on the "Insert" tab in the ribbon and then click on "Picture".
2. Select the picture file that you want to insert and then click on "Insert".
3. Resize and position the picture as needed in cell A1.
4. Go back to Sheet 1 and select cell B40.
5. Type the following formula in the formula bar at the top of the screen: =Sheet2!A1
6. Press enter to apply the formula. You should now see the picture that you inserted in Sheet 2, cell A1 displayed in Sheet 1, cell B40.
That's it! The picture should now be displayed in Sheet 1, cell B40 and it will automatically update if you make changes to the picture in Sheet 2, cell A1.
