Thread: Importing data from another excel file automatically
View Single Post
  #2  
Old 03-04-2007, 11:15 PM
duane duane is offline
Forum Guru
  
Join Date: 11 Jul 2004
Posts: 847
duane is an unknown quantity at this point
try this

=INDIRECT("LLLLL'["&C5&".xls]SSSSS'!CCC")

where LLLLL is the file location (drive and directory)
C5 is the cell where I put the file name
SSSSS is the worksheet name of the file in question
CCC is the cell desired
__________________
not a professional, just trying to assist.....
Reply With Quote