AutoUpdate links / Workbooks saved by date???

[Teddy-B]

We have a master template that we use to start a new day's workbook every
day. We want the closing balance from the previous day's workbook to link
into the template in the opening balance cell. We can link any two workbooks,
but how do we get the templete to automatically link to the previous day's
workbook?

 

[Pete_UK]

If both files are open at the same time then you could use INDIRECT
and calculate the filename from TODAY() (making adjustments on Monday
to avoid weekend dates).

If you want to use this approach but the older file will not be open,
then you can download the free add-in morefunc, which has a function
INDIRECT.EXT to allow you to do this.

Another way (though not automatic) would be to use Find & Replace
(CTRL-H) to change [filename_mmddyy.xls] to [filename_mmttyy.xls],
where mmddyy is the date in your template and mmttyy is yesterday's
date (or however you have date-stamped the file) for the formulae
which link to the file.

Hope this helps.

Pete

 

[Teddy-B]

Can you help me find an active site that will allow me to download the
morefunc add-in?

If both files are open at the same time then you could use INDIRECT
and calculate the filename from TODAY() (making adjustments on Monday
to avoid weekend dates).

If you want to use this approach but the older file will not be open,
then you can download the free add-in morefunc, which has a function
INDIRECT.EXT to allow you to do this.

Another way (though not automatic) would be to use Find & Replace
(CTRL-H) to change [filename_mmddyy.xls] to [filename_mmttyy.xls],
where mmddyy is the date in your template and mmttyy is yesterday's
date (or however you have date-stamped the file) for the formulae
which link to the file.

Hope this helps.

Pete

We have a master template that we use to start a new day's workbook every
day. We want the closing balance from the previous day's workbook to link
into the template in the opening balance cell. We can link any two workbooks,
but how do we get the templete to automatically link to the previous day's
workbook?