| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link to a workbook whose name is variable?
I want to create a link from one workbook to another based upon variable data.
For example, if the cell A1 contains AAAAA then the link should be to a workbook named AAAAA.xls if the cell A1 contains BBBBB then the link should be to a workbook named BBBBB.xls Is this possible in Excel 2000? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I link to a workbook whose name is variable?
Something like this
=INDIRECT("'" &A1&"Gantt Chart'!$A$7") with a name style of [Gantt.xls] in the cell, but it will only work with open workbook. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Carl Borthwick" <Carl wrote in message ... I want to create a link from one workbook to another based upon variable data. For example, if the cell A1 contains AAAAA then the link should be to a workbook named AAAAA.xls if the cell A1 contains BBBBB then the link should be to a workbook named BBBBB.xls Is this possible in Excel 2000? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I merge and link workbooks into one summary workbook? | Excel Worksheet Functions | |||
| link from one workbook to another workbook using a dropdown? | Excel Worksheet Functions | |||
| link data to new workbook | Excel Discussion (Misc queries) | |||
| how can i link sheets in my excel workbook | Excel Worksheet Functions | |||
| How do I link sorted data to other workbook sheets? | Excel Worksheet Functions | |||
Linear Mode
