Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print odd pages and even pages seperately in Excel. | Excel Discussion (Misc queries) | |||
I need to print only odd pages & then even pages | Excel Discussion (Misc queries) | |||
Make a formula to calculate the avarage of baseball stats | Excel Worksheet Functions | |||
How can I number pages so it changes every 3 pages? | Excel Discussion (Misc queries) | |||
How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) |