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