software

I would like to take separate workbook totals and create a workbook that will
calculate all of the totals inputted without having to manually go into the
workbook and input the totals.
Example if i have monthly total in one workbook say Feb and in another
workbook I have March's monthly total and so on, how would I take those
totals and have them automatically transfer to another workbook that would
give me year end totals?

A variation on Gary's suggestion, in case your monthly totals aren't all in
the same cell addresses: give each total a range name, MonthlyTotal

Then Gary's formula could be changed to

=Jan.xls!MonthlyTotal Feb.xls!MonthlyTotal Mar.xls!MonthlyTotal.....

quot;Cindyquot; wrote:

gt; I would like to take separate workbook totals and create a workbook that will
gt; calculate all of the totals inputted without having to manually go into the
gt; workbook and input the totals.
gt; Example if i have monthly total in one workbook say Feb and in another
gt; workbook I have March's monthly total and so on, how would I take those
gt; totals and have them automatically transfer to another workbook that would
gt; give me year end totals?