I use Windows XP, Excel 2003 on one computer; and Windows Vista, Excel 2007,
on another one. This question refers to both operating systems and Excel
versions.


I maintain detailed Excel spreadsheets that contain cumulative information
to which daily data are posted (referred to as Report A). Report A data are
linked to another spreadsheet (Report B) that reports only the most recent
daily data. Each day, I have to manually update the references on Report B so
the data for that day from Report A can post. This is tedious and time
consuming. I have searched for solutions to my problem, but with no success.
Is there any way I can have the references on Report B automatically
increment each day to preclude my manually having to do it?