Excel formula - overwritten files and data

[dmeconi]

I need to set up on a shared drive a "production shift letter" which contains
data to be saved by the date it was written. The problem is, the next day,
the file will be re-written, data changed and the file saved under the same
name as the first day, day after day.
What formula can be used to grab the data, save it by the current date and
hold that data when the file changes to another date.
Any assistance would be helpful.

 

[Guest]

hi,
=today() or =now() or = date will do the date
not sure about the overwrite part. fomulas are not
overwritten.
but...
=cell address, =text
if the data is in another file, you may have to add the
file path something like this
=H:\CodeStuff\[ConnectPaths.xls]Sheet1'!A5