average worksheet values in workbook problem

potts

Board Regular
Joined
Jul 9, 2004
Messages
86
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?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

potts

Board Regular
Joined
Jul 9, 2004
Messages
86
Does it matter if the sheets are named differently? For example, if they were named by date: 02-10-06.
 

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,934
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
 

Forum statistics

Threads
1,141,625
Messages
5,707,476
Members
421,510
Latest member
haroonstr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top