File Name Retrieval

  • Thread starter Thread starter Wayne Hunter
  • Start date Start date
W

Wayne Hunter

Hi,

Got a good one for the EXPERTS. I've got a cell which
I wish to reference another cell in another file. I want
the reference to be automatic based on an input date on
the original file. This would mean that if my input date
is 03 OCT 03 then I would want the cell to reference
filename 03 OCT 03.xls and of course the referenced cell
in that file for the value. The problem is that any
function I use doesn't work, because it seems I have to
physically change the filename each time I create a new
file based on the template. I've tried the ampersand (&)
function but that doesn't work, it only returns either
the cell name i.e L1 or another literal value. Is there
anyway to lookup a filename based on a cell value?

Thanks

Wayne
 
With "03 Oct 03" (no quotes) in cell A12, using

=INDIRECT("'"&A12&"'!C1")

will retrieve the value in cell C1 in "03 Oct 03.xls" The
source file must be open.

HTH
Jason
Atlanta, GA
 
Back
Top