average worksheet values in workbook problem

[potts]

I wonder if someone could help....

I want to calculate the average of the same cell reference of each sheet within a workbook.

For example:
I have 30 worksheets in a workbook. The first 29 contain raw data. The last sheet is a summary sheet.

In the summary sheet I want to display an average value of the data inputted into cell C10 for the first 29 sheets. Rather than input all the references manually, I would like to create a macro that does this for me. Does anyone know how to do this?

 

[eliW]

Just:

=AVERAGE(Sheet1:Sheet29!C10)

Eli

 

[potts]

Does it matter if the sheets are named differently? For example, if they were named by date: 02-10-06.

 

[eliW]

Does it matter if the sheets are named differently? For example, if they were named by date: 02-10-06.

Of course not. Click on the first tab and while pressing Shift button click on the last tab.


Eli