How to link cells in two workbooks that change daily?

Giganews Newsgroups
Subject: How to link cells in two workbooks that change daily?
Posted by:  Doc Adams
Date: Sat, 13 May 2006

I have an Excel workbook named “template” which I open daily, make changes
to, and then close at the end of the day saving it with that day's date for a
file name. (Example open the blank workbook daily named “Template” - Close
Template at the end of the day and name it that for day's date, for example
5-12-2006)

I would like to open “Template” every day, but with a total from
yesterday’s workbook. Example, on 5-13-2006 open “template” but with a grand
total sum that is in a cell that is within the workbook now named
“5-12-2006.” The purpose is, of course, to start each new day with
yesterday’s grand total.

Thanks for any and all ideas. Doc

Replies