Excel Linking Cells between workbooks...

In Excel 95 I need to link cells from one workbook to another. The problem is that the *TITLE* of the source workbook (it is a daily report) changes daily and is saved each day according to the date. So obviously I can't link to the cells in 8-31-00.xls because in a couple of days the information I need, while still in the same cells (e.g. B1, B2, B3...), is in the latest daily report, say for example 9-2-00.xls

Does that make sense? My cell references that I need stay the same but each day the worksheet I need to grab the data from has a different name according to the current date.

If the report stayed the same I could just link to: =[9-2-00.xls]Sheet1!$B$2

Is there anyway to link something like:
=[todaysdate.xls]Sheet1!$B$2

???

Sorry if this is unclear.
Thanks for any suggestions.

jase.

A few ideas I have (though none are automated, sorry)

1. Can you copy and paste each day's new values into the same workbook all the time (replace the old values)? That way your formula can reference the same cell, but you change the contents.

2. Try a find and replace to change each date to the new one needed. A little rough but it goes quickly.

Scott

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

Linking Cells between workbooks...

Re: Linking Cells between workbooks...