Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages..

  • Thread starter Thread starter GE Cathey
  • Start date Start date
G

GE Cathey

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/
 
Check your other post.

GE said:
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/
Click to expand...
 
Cathey

Post the URL for the template you're using.

I'll d/l and have a look.


Gord Dibben MS Excel MVP
 
If you look at a formula on the summary worksheet, you'll see that they look
like:

=SUM('Game 1:Game 23'!D3)

If you insert the new worksheet to the right of "game 23" (or to the left of
"Game 1"), you'll have to change the formula.

But you could just insert the new game in between those two worksheets. It
might look a little weird if you see

Game 1, Game 2, ..., Game 24, Game 25, then Game 23

but the summary worksheet will work fine.
 
Ps. You may want to ask the developer (for next year???) to add a couple more
worksheets. One would be called Start and the other End--and all the game
worksheets would have been between those two.

And the formula would be changed to:

=SUM('Start:End'!D3)
 
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 Tools>Protection>Unprotect sheet...no
Password required.

Edit>Replace

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
 
Start and End will just be blank dummy sheets.

Leave them that way.

The SUM function ignores blank cells on these sheets so does not affect the
Summary outcome.


Gord
 
Back
Top