George

Easiest method to do this is the add two new sheets.

Insert a new sheet between Summary and Game 1........name it Start

Add a new sheet after Game 23...............name it End

Go to to Summary sheet and CTRL + a(twice in 2003) to select all cells.

Note: first unprotect the sheet from ToolsProtectionUnprotect sheet...no
Password required.

EditReplace

What: Game 1:Game 23

With: Start:End

Replace All

Now when you want a new Game sheet just copy Game 23 before End sheet and rename
to Game 24 and onward as you need more sheets.

All sheets between Start and End will be included in the Summary formulas.


Gord

On Thu, 17 May 2007 12:21:43 -0500, GE Cathey wrote:

Hi Gord,

Thanks for your help -- here is the url for the site.
http://chelseayouthclub.org/joomla/i..._details&gid=6
The file is called "Team_Stats.xls"

George








Gord Dibben wrote:

Cathey

Post the URL for the template you're using.

I'll d/l and have a look.


Gord Dibben MS Excel MVP

On Wed, 16 May 2007 12:42:14 -0500, GE Cathey wrote:



Need Help -- Baseball stats in excel only has 23 pages--Need to add more
pages...and have the "summary function" work on all pages.

Someone I don't know, set this spreadsheet up and it keeps game by game
info such as batting averages and slugging averages and it keeps same
info as a "season summary". I added the extra pages I needed but
unfortunately, the season summary doesn't take account of any info past
page 23.

Any ideas?

George Cathey


Don't go to this link unless you want to see some sports illustrations
(other stuff too)

http://www.workbook.com/portfolios/cathey/