Totalling workbooks

[Guest]

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

 

[Anne Troy]

Try the method described here:

http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm

*******************
~Anne Troy

www.OfficeArticles.com

 

[Tom Ogilvy]

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.

 

[Guest]

Thanks for the advice, yes i did mean workbooks and figured i'd have to do
your summary idea Tom, thanks