Thread: Referencing Cell Info to call a File
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
  
Posts: 1,397
Default Referencing Cell Info to call a File
Check out the indirect() function in help

"stuckupnorth" wrote:


I would like to use a cell value in a formula to identify a workbook
name.
e.g. ='[File_Info!B2]1 - General Statistics'!$C$21

File_Info :- is a worksheet in the same workbook
B2 :- is the cell in the worksheet that holds the filename
(OtherFile.XLS)
1 - General Statistics :- is the worksheet in OtherFile.XLS
$C$21 :- is the cell in OtherFile.XLS I would like to call

At the moment it is just looking for a file called "File_Info!B2", how
can I get it to call the information from worksheet and cell
"File_Info!B2" and then use the called information as the filename??



--
stuckupnorth
------------------------------------------------------------------------
stuckupnorth's Profile: http://www.excelforum.com/member.php...o&userid=31330
View this thread: http://www.excelforum.com/showthread...hreadid=559261


Reply With QuoteReply With Quote