| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a changing cell reference as part of a workbook name 2 link
I am trying to link cell "A1" in workbook1 "stats X" to cell "A1" in
workbook2 "12-May-2009 Stats Y" by using cell "B1"(12-May-2009) as part of the reference to workbook2 e.g. A1= K:\Stats\[12-May-2009 Stats sheet.xls]PERSON NAME'!$Q$40 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a changing cell reference as part of a workbook name 2 link
Try
=INDIRECT(A1) If this post helps click Yes --------------- Jacob Skaria "Jason" wrote: I am trying to link cell "A1" in workbook1 "stats X" to cell "A1" in workbook2 "12-May-2009 Stats Y" by using cell "B1"(12-May-2009) as part of the reference to workbook2 e.g. A1= K:\Stats\[12-May-2009 Stats sheet.xls]PERSON NAME'!$Q$40 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a changing cell reference as part of a workbook name 2 l
THANK YOU, but I do not know how to implement that function.
Workbook1 [Stats X] A B 1. I want this cell to equal cell A1 in [12-06-2009 Stats.xls] 12-06-09 --------------------------------------------------------------------------------------- Workbook2 K:\Directory\Subdirectory\[12-06-2009 Stats.xls] A 1. 8:00:00 -------------------------------------------------------------------------------------- Any further help in how to write the string would be appreciated "Jacob Skaria" wrote: Try =INDIRECT(A1) If this post helps click Yes --------------- Jacob Skaria "Jason" wrote: I am trying to link cell "A1" in workbook1 "stats X" to cell "A1" in workbook2 "12-May-2009 Stats Y" by using cell "B1"(12-May-2009) as part of the reference to workbook2 e.g. A1= K:\Stats\[12-May-2009 Stats sheet.xls]PERSON NAME'!$Q$40 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link to other workbook with changing filename | Excel Worksheet Functions | |||
| How do I link part of an Word document into an Excell workbook? | Excel Discussion (Misc queries) | |||
| Can references to cells be used as part of a workbook reference | Excel Discussion (Misc queries) | |||
| Using a cell reference as part of a link | Excel Discussion (Misc queries) | |||
| External reference changing the link | Excel Discussion (Misc queries) | |||
Hybrid Mode
