Hello Everyone,
I have created a sheet ('Picture-Shapes') which has 10 different shapes. These shapes are then called on in other sheets by referencing them as pictures using this method: http://excel.tips.net/T003128_Displa..._a_Result.html
This is working well but now i would like to add dimensions to the pictures by referencing cells. I have achieved this using text boxes on the original sheet with the shapes ('Picture-Shape') but I can only reference cells from the same sheet. I want to reference cells from the active sheet so that when the image is used on any sheet it uses data from that active sheet.
Is this possible using formula?
Would a Label be another option?
Thanks for your help,
Andrew
Bookmarks