2003 Excel Workbooks
 

Hi,

I'm a very novice Excel user. I've created a budget, with the first page of
the workbook being my total combined budget. The remaining workbook pages
have the details of all budget lines listed on the first page, complete with
running totals.

How can I (or can I) take all of the totals from the rest of the workbooks
and have it continually subtract from the grand total of my first page?

Thanks!

2003 Excel Workbooks
 

Before getting to a solution let's establish what you currently have.

A workbook consists of one or more worksheets, not "pages", not "workbooks".

Do you have a workbook with multiple worksheets with the first worksheet being
the total combined budget and the details on other worksheets?

If so, you can use what is known as 3D References to calculate across multiple
worksheets.

e.g. in sheet1 cell A1 enter this formula...........=SUM(Sheet2:Sheet5!B1)

This will SUM all B1's from each sheet to give a total in Sheet1 A1


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 12:49:04 -0800, STOP-DWI
wrote:

Hi,

I'm a very novice Excel user. I've created a budget, with the first page of
the workbook being my total combined budget. The remaining workbook pages
have the details of all budget lines listed on the first page, complete with
running totals.

How can I (or can I) take all of the totals from the rest of the workbooks
and have it continually subtract from the grand total of my first page?

Thanks!