| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.links
|
|||
|
|||
How to make an external link to a filename defined by a cell v
If the source cells are in the same workbook then INDIRECT will work
(since by definition the workbook containing the cells is open). =INDIRECT("'" & CellContainingSheetName & "'!$A$1") for example Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
| How to link cell for value in another cell of pivot table? | Excel Discussion (Misc queries) | |||
| How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
