Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Totalling workbooks
I am creating a summary worksheet and i was wondering if it is possible to
add values together from different workbooks and then have it automatically update when i create a new workbook, the workbooks being named week 16, week 17 and so on in number order. So that when i create week 18, the figures get included into the summary |
#2
|
|||
|
|||
Try the method described he
http://www.officearticles.com/excel/...rk sheets.htm ******************* ~Anne Troy www.OfficeArticles.com "blummincars" wrote in message ... I am creating a summary worksheet and i was wondering if it is possible to add values together from different workbooks and then have it automatically update when i create a new workbook, the workbooks being named week 16, week 17 and so on in number order. So that when i create week 18, the figures get included into the summary |
#3
|
|||
|
|||
Note that this method does not work for workbooks. If by workbooks, you
meant worksheets, then your on your way. If you really meant workbooks as you stated, then you might adapt to this method by inserting a new sheet in the summary workbook to summarize the individual workbooks - then have a final sheet to summarize year to date. -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... Try the method described he http://www.officearticles.com/excel/...rk sheets.htm ******************* ~Anne Troy www.OfficeArticles.com "blummincars" wrote in message ... I am creating a summary worksheet and i was wondering if it is possible to add values together from different workbooks and then have it automatically update when i create a new workbook, the workbooks being named week 16, week 17 and so on in number order. So that when i create week 18, the figures get included into the summary |
#4
|
|||
|
|||
Thanks for the advice, yes i did mean workbooks and figured i'd have to do
your summary idea Tom, thanks "Tom Ogilvy" wrote: Note that this method does not work for workbooks. If by workbooks, you meant worksheets, then your on your way. If you really meant workbooks as you stated, then you might adapt to this method by inserting a new sheet in the summary workbook to summarize the individual workbooks - then have a final sheet to summarize year to date. -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... Try the method described he http://www.officearticles.com/excel/...rk sheets.htm ******************* ~Anne Troy www.OfficeArticles.com "blummincars" wrote in message ... I am creating a summary worksheet and i was wondering if it is possible to add values together from different workbooks and then have it automatically update when i create a new workbook, the workbooks being named week 16, week 17 and so on in number order. So that when i create week 18, the figures get included into the summary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions | |||
Tools/Compare and Merge Workbooks - Excel 2003 Pro | Excel Worksheet Functions | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |