I have a report that summarizes activity from another worksheet. I want to
be able to update/change the formula if the date of the report changes. As
an example:

" =SUM(U:\Drew\[INVWKSH09.xls]1996'!$B$409:$B$411)"

and I want the formula to change so that whne the date of the report
changes, the formula would change to $B$411:$B$413

Thank for the help.


--
Allan