Thread: Referencing Cell Info to call a File
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stuckupnorth stuckupnorth is offline
external usenet poster
  
Posts: 1
Default Referencing Cell Info to call a File

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