Consolidate Auto to 1 sheet from many

[Dale Holden]

Hi

Sorry for this simple question but i cannot remember how to do this.
Setup

I have 1 workbook with 13 sheets.
Sheet 1 the yearly sheet Eg 2004
Sheets 2to 13 Months of the year
Each data entry area are identical on each sheet.

I want any data entered in any of the monthly sheets to update and
consolidate data in the yearly sheet. So the data adds up the totals
of all the shhets.

I know how to copy and paste to consolidate the data manually but i
want to know how you set up the workbook to do it automatically!

Cheers Dale

 

[Govind]

Lets say you want to consolidate in Sheet 1, a data which is in Cell A1
of sheets 2 to 13 , then use this formula

=SUM(Sheet2:Sheet13!A1)

But this can be done only when the sheets 2 to 13 are identical in terms
of cell location etc.

Regards

Govind

 

[\Thorrrr\]

Great

If the sheets have names like Jan Feb Mar how does that work ????

 

[Frank Kabel]

Hi
just use
=SUM('jan:dec'!A1)