If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages..
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/ |
#2
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Need toaddmore pages..
Check your other post.
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/ -- Dave Peterson |
#3
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Need to add more pages..
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/ |
#4
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Needto add more pages..
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/ |
#5
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Need toaddmore pages..
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. 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/ -- Dave Peterson |
#6
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Need toaddmore pages..
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) 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/ -- Dave Peterson |
#7
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Need to add more pages..
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/ |
#8
|
|||
|
|||
Need Help -- Baseball stats in excel only has 23 pages--Need to add more pages..
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 On Thu, 17 May 2007 13:34:12 -0700, Gord Dibben gorddibbATshawDOTca wrote: 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/ |
Thread Tools | |
Display Modes | |
|
|