linking object to cells
I have a workbook with two worksheets. The first worksheet (01) has a
picture of cells A4: J25 in the second worksheet (02). I would like that when I double click the screendump in sheet01 it takes me to cells A4:E4 in sheet 2, I've managed this by using a hyperlink. However, I would also like that when any cells in the given range in sheet 02 are updated the picture in sheet01updates with the information from sheet02 as well. I've tried pasting the picture as a link, but the paste link button is inactive, how do I get round this. -- Trainer |
linking object to cells
Hi,
Your first part of the paragraph is what will actualy happen, but if you would like the given cell in Sheet 2 to automatically update in Sheet 1, this will not happen, because the Sheet 1 range is already defined as picture. You can only do this outside the picture range in sheet 1. Challa Prabhu "Trainer" wrote: I have a workbook with two worksheets. The first worksheet (01) has a picture of cells A4: J25 in the second worksheet (02). I would like that when I double click the screendump in sheet01 it takes me to cells A4:E4 in sheet 2, I've managed this by using a hyperlink. However, I would also like that when any cells in the given range in sheet 02 are updated the picture in sheet01updates with the information from sheet02 as well. I've tried pasting the picture as a link, but the paste link button is inactive, how do I get round this. -- Trainer |
All times are GMT +1. The time now is 11:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com