|
| 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
May 16th 07, 06:42 PM
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/ 
|
| Ads |
|
#2
May 16th 07, 08:23 PM
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
May 16th 07, 08:53 PM
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
May 17th 07, 06:21 PM
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
May 17th 07, 07:02 PM
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
May 17th 07, 07:04 PM
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
May 17th 07, 09:34 PM
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 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 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
May 17th 07, 09:42 PM
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 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 > >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 | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to print odd pages and even pages seperately in Excel. | DILNAVAS | Excel Discussion (Misc queries) | 1 | June 14th 06 11:45 AM |
| I need to print only odd pages & then even pages | Wink | Excel Discussion (Misc queries) | 1 | May 27th 06 03:22 PM |
| Make a formula to calculate the avarage of baseball stats | Confused at Work | Excel Worksheet Functions | 2 | May 11th 06 03:05 PM |
| How can I number pages so it changes every 3 pages? | tina | Excel Discussion (Misc queries) | 0 | February 16th 06 12:28 AM |
| How do I delete pages from an Excell template of mutiple pages | pulcom123 | Excel Discussion (Misc queries) | 2 | December 30th 05 04:41 PM |
Linear Mode
