Forum Discussion
Excel - I want to get the excel sheet to display a Picture on the Next sheet..
Hi there, I've had a stroke so.. Bear with me.. LOL
ie..
Sheet 1 - B40 on the Sheet to automatically display a Picture From the Next Sheet (Sheet 2) - A1
Hope this makes sense.
A40 B40
Attachments: PIC 1
4 Replies
- 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.So Close, but I don't want the Picture to end up at Sheet1 A1, Only to have the Sheet changed to Sheet 2 A1
- I think this is only possible with VBA.
