Linking Cells between workbooks...
Posted by jase. on September 01, 2000 9:06 PM
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:
Sorry if this is unclear.
Thanks for any suggestions.