| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to link cells in two workbooks that change daily?
I have an Excel workbook named template which I open daily, make changes
to, and then close at the end of the day saving it with that day's date for a file name. (Example open the blank workbook daily named Template - Close Template at the end of the day and name it that for day's date, for example 5-12-2006) I would like to open Template every day, but with a total from yesterdays workbook. Example, on 5-13-2006 open template but with a grand total sum that is in a cell that is within the workbook now named 5-12-2006. The purpose is, of course, to start each new day with yesterdays grand total. Thanks for any and all ideas. Doc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Can you link many workbooks to one template? And Update? | Excel Discussion (Misc queries) | |||
| Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
| Variable Link to Workbooks | Excel Worksheet Functions | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
Threaded Mode
