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
|