| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Linking WorkBOOKS across directories | Excel Worksheet Functions | |||
| linking to multiple workbooks | Excel Discussion (Misc queries) | |||
| Linking WorkBooks Based on Data Entered In One of Them | Excel Discussion (Misc queries) | |||
| Linking Workbooks | Excel Worksheet Functions | |||
Linear Mode
