Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoUpdate links / Workbooks saved by date???
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoUpdate links / Workbooks saved by date???
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 On Oct 30, 6:38*pm, Teddy-B wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoUpdate links / Workbooks saved by date???
Can you help me find an active site that will allow me to download the
morefunc add-in? "Pete_UK" wrote: 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 On Oct 30, 6:38 pm, Teddy-B wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links between workbooks | Links and Linking in Excel | |||
Cannot create new hyperlinks in saved workbooks | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Values In Links Not Being Saved | Excel Worksheet Functions | |||
Links to other workbooks | Excel Worksheet Functions |