Linking workbooks
Morning All
Can I link a cell on one worksheet to a particular sheet within another workbook? I have tried using hyperlink but it just takes me to the index page each time not a specific sheet. TIA Ajay |
Linking workbooks
Select the "sending" cell
edit|copy Select the receiving cell Edit|Paste Special|click Paste Link You'll see a formula like: =Sheet2!A1 This formula will return a 0 if that sending cell is empty. You can modify the formula to make it look blank by using something like: =if(sheet2!a1="","",sheet2!a1) Ajay wrote: Morning All Can I link a cell on one worksheet to a particular sheet within another workbook? I have tried using hyperlink but it just takes me to the index page each time not a specific sheet. TIA Ajay -- Dave Peterson |
All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com