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

J

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
 
J

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

Jacob Skaria said:
Try

=INDIRECT(A1)

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


Jason said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy worksheet to 2nd workbook but have no reference to 1st workbo 8
referencing a named range in another workbook 1
Using cell as worksheet reference (macro) 1
How to use result from some function as a part of cell reference? 2
Use worksheet name in one cell as part of reference in other cells 3
Straight Line is not straight 2
Making the AND function look at only part of a cell entry 2
Function to put worksheet name in cell returns text, need number 5

Top