Formula or Link to file with changing file name ???

  • Thread starter Thread starter TimLucky1
  • Start date Start date
T

TimLucky1

I would like to formula or link to a spreadsheet we use that we name with
today's date like '12-22-03.xls" I would like a formula that will look at a
cell and subtract one day from the date and look for a file in a particular
folder with that date. and come back with information from a cell or a group of
cells. Am I asking too much?

Thanks
 
You could use the INDIRECT function to return the reference. For
example, if cell C2 contains the date:

=INDIRECT("'["&TEXT(C2-1,"mm-dd-yy")&".xls]Sheet1'!$B$5")
 
Tim
I don't think you can use the INDIRECT function. The other file has to be open for this function to work. I think you'll need some VB if you need to query closed workbooks

Good Luck
Mark Graesse
(e-mail address removed)

----- Debra Dalgleish wrote: ----

You could use the INDIRECT function to return the reference. For
example, if cell C2 contains the date

=INDIRECT("'["&TEXT(C2-1,"mm-dd-yy")&".xls]Sheet1'!$B$5"

TimLucky1 wrote
 
Oops! You could use the UDF to retrieve data from a closed file, that
Harlan Grove posted:


http://google.com/[email protected]


With the date in cell C2, and the lookup file in the same folder, your
formula would be:


=pull("'"&INFO("Directory")&"["&TEXT(C2-1,"mm-dd-yy")&".xls]Sheet1'!$B$5")

Mark said:
Tim,
I don't think you can use the INDIRECT function. The other file has to be open for this function to work. I think you'll need some VB if you need to query closed workbooks.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Debra Dalgleish wrote: -----

You could use the INDIRECT function to return the reference. For
example, if cell C2 contains the date:

=INDIRECT("'["&TEXT(C2-1,"mm-dd-yy")&".xls]Sheet1'!$B$5")
I would like to formula or link to a spreadsheet we use that we name with
today's date like '12-22-03.xls" I would like a formula that will look at a
cell and subtract one day from the date and look for a file in a particular
folder with that date. and come back with information from a cell or a group of
cells. Am I asking too much?
Click to expand...
Click to expand...
 
Back
Top