| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to breakdown link to a separate workbook
I would like to be able to display in a cell the root of the workbooks being
linked to. And have cells below this, use the roots together with a cell reference to retrieve data. EG a1: 'c:\data\[spreadsheet1]page1' a2: 'c:\data\[spreadsheet2]page1' a4: sum of cell b1 in spreadsheets named above Any help would be much appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One workbook to another . . . | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Link A Cell In O ne Workbook To A Formula In Another Workbook | Excel Worksheet Functions | |||
| How do I link data from another workbook using a different file na | Excel Discussion (Misc queries) | |||
| Link to password protected workbook | Excel Discussion (Misc queries) | |||
Linear Mode
