Thread: confused by linking to Cells in Other Workbooks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
  
Posts: 477
Default confused by linking to Cells in Other Workbooks
In my WB1.xls I have:
In Cell A6 '0514121-A
In cell B6 ="[PA"&A6&"-JM.xls]PaySchedule"
In Cell Z1 'C:\Documents and Settings\Contracts\

In Cell G6 << I need to link to Cell D10 (with a dollor Value in

Z1 & B6 ' or 'C:\Documents and
Settings\Contracts\="[PA"&A6&"-JM.xls]PaySchedule"

PA0514121-A-JM.xls will remain Closed throughout.

Any help would be appreciated

Reply With QuoteReply With Quote