Hello is there a way to have various places in the workbook that contain a logo from a cell on one sheet? If the logo changes in that cell it will also change in the selected cells in the workbook.
Thank you for your help in advance.
Hello is there a way to have various places in the workbook that contain a logo from a cell on one sheet? If the logo changes in that cell it will also change in the selected cells in the workbook.
Thank you for your help in advance.
Have a look at the camera feature.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe I didn't explain it properly.
For example if I have 5 cells that will need the logo in them and I change the logo in one cell it will change in all cells.
Yes. One way is to use camera tool.
Another way.
1. Insert picture into sheet. Ensure entire picture fits inside a cell (Ex: A2).
2. Copy picture into each location it should appear. In formula bar of each picture enter address of original picture. (Ex: Sheet1!A2).
3. Replace image in Sheet1!A2 and rest will change along with it.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Did you have a look at the camera feature? If you do, you will see why I have suggested it.
The camera tool is not at all what I intended. I wanted the cells throughout the workbook to change if the parent cell changes.
Thanks anyway
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks