Function to automatically change formulas...?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!

I have some files that are copied on a daily basis. Essentially, i would
like to compare the value of the current file with the previous day's values.

I have the path and filename calculated and contactanated automatically in a
cell using today()-1 and contactanate function. This concatanate
function/formula results in a value such as G:\path\file_17-8-2004.xls

I currently have cells that I type in manually to reflect values such as
G:\path\file_17-8-2004.xls!cellname

What I would like to do is basically have G:\path\file_17-8-2004.xls
changing to G:\path\file_18-8-2004.xls, etc. based on the current date.

Any help/ ideas are welcome please.
 
Do you mean this? Correct for wordwrap
="G:\path\file_"&DAY(TODAY()-1)&"-"&MONTH(TODAY()-1)&"-"&YEAR(TODAY()-1)&".x
ls"
 
Hi
do you need the referenced value from this string? And another
question: If yes is this other file closed?
 
Hi
then INDIRECT won't work. Have a look at the following thread for some
alternatives:
http://tinyurl.com/2c62u

In your case you may use INDIRECT.EXT. e.g.
=INDIRECT.EXT("'G:\path\[file_" & TEXT(TODAY(),"DD-M-YYYY") &
".xls]sheet1'!X1")
 
Thanks a million!

Frank Kabel said:
Hi
then INDIRECT won't work. Have a look at the following thread for some
alternatives:
http://tinyurl.com/2c62u

In your case you may use INDIRECT.EXT. e.g.
=INDIRECT.EXT("'G:\path\[file_" & TEXT(TODAY(),"DD-M-YYYY") &
".xls]sheet1'!X1")

--
Regards
Frank Kabel
Frankfurt, Germany

venkat said:
Hello Frank

Yes, the other file is closed, and yes, i need the referenced value, ex:

g:\path\file_31-12-04.xls!cellname
Click to expand...
Click to expand...
 
Back
Top