Using a changing cell reference as part of a workbook name 2 link

[Jason]

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

 

[Jacob Skaria]

Try

=INDIRECT(A1)

If this post helps click Yes

 

[Jason]

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

Try

=INDIRECT(A1)

If this post helps click Yes
---------------
Jacob Skaria

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