Thread: Using a changing cell reference as part of a workbook name 2 link
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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
Reply With QuoteReply With Quote