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

-----Original Message-----
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.
.