Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Database Problems
Hi,
I'm creating an excel workbook, that has information about stats from my football team. One sheet has ALL the information (stats), and another sheet is my overview sheet with only pertinent information that we want to see. On the second sheet (overview sheet), the information is broken up into player positions (ie. Quaterback stats, then running back stats, etc). On sheet 1 (with all the data), it is in alphebetical order and we want to keep it like that. The problem I am having is that if I add or delete a player on Sheet 1, it screws up my overview sheet, because now I have running backs in the quarterback section, and so on throughout the entire sheet. Is there a way to set up my overview sheet so that when I add or delete a player in sheet 1, the categories (ie. Quaterback stats) on sheet 2 remain in tact, without a shifting of records? Also, is there a way so that when I add a player in Sheet 1, it will automatically categorize that player into their respective category in sheet 2? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Database Problems
You need to link the two sheets by their position on the field rather then
position on the worksheet. So for the quarterbacks put QB or Running Backs RB, and so on. Then you can easily sort by position on the 1st sheet and when you are gathering stats on the second sheet you can refer to the position directly like Sumif(Range,"QB",Sum_Range). Things like Sumif, Vlookup, Countif, etc would all work well taking information from sheet one using the identifier like QB or RB. "Terrill" wrote: Hi, I'm creating an excel workbook, that has information about stats from my football team. One sheet has ALL the information (stats), and another sheet is my overview sheet with only pertinent information that we want to see. On the second sheet (overview sheet), the information is broken up into player positions (ie. Quaterback stats, then running back stats, etc). On sheet 1 (with all the data), it is in alphebetical order and we want to keep it like that. The problem I am having is that if I add or delete a player on Sheet 1, it screws up my overview sheet, because now I have running backs in the quarterback section, and so on throughout the entire sheet. Is there a way to set up my overview sheet so that when I add or delete a player in sheet 1, the categories (ie. Quaterback stats) on sheet 2 remain in tact, without a shifting of records? Also, is there a way so that when I add a player in Sheet 1, it will automatically categorize that player into their respective category in sheet 2? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Database Problems
Will this still work if I want to set it up like this:
Sheet 1: Name Age Position Ht Wt. 40yd Chris 23 QB 6'2 182 4.3 Dave 21 RB 6'2 192 4.0 Jason 24 QB 6'3 201 4.1 Jason 27 DB 6'0 198 4.2 Jeff 26 FB 5'9 188 4.4 Mat 23 RB 5'10 187 4.2 Stan 25 DB 6'0 210 4.3 Sheet 2: Quaterbacks: Chris 23 QB 6'2 Jason 24 QB 6'3 Running Backs: Dave 21 RB 6'2 Jeff 26 FB 5'9 Mat 23 RB 5'10 Defensive Backs: Jason 27 DB 6'0 Stan 25 DB 6'0 The first sheet is the main sheet where I will have all the information. The second sheet will be a summary page with only the data we want to show. If we want to categorize it as shown, how would we go about doing this? What would be the best way to have this happen? "akphidelt" wrote: You need to link the two sheets by their position on the field rather then position on the worksheet. So for the quarterbacks put QB or Running Backs RB, and so on. Then you can easily sort by position on the 1st sheet and when you are gathering stats on the second sheet you can refer to the position directly like Sumif(Range,"QB",Sum_Range). Things like Sumif, Vlookup, Countif, etc would all work well taking information from sheet one using the identifier like QB or RB. "Terrill" wrote: Hi, I'm creating an excel workbook, that has information about stats from my football team. One sheet has ALL the information (stats), and another sheet is my overview sheet with only pertinent information that we want to see. On the second sheet (overview sheet), the information is broken up into player positions (ie. Quaterback stats, then running back stats, etc). On sheet 1 (with all the data), it is in alphebetical order and we want to keep it like that. The problem I am having is that if I add or delete a player on Sheet 1, it screws up my overview sheet, because now I have running backs in the quarterback section, and so on throughout the entire sheet. Is there a way to set up my overview sheet so that when I add or delete a player in sheet 1, the categories (ie. Quaterback stats) on sheet 2 remain in tact, without a shifting of records? Also, is there a way so that when I add a player in Sheet 1, it will automatically categorize that player into their respective category in sheet 2? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 case sensitive problems with New Database Query | Excel Discussion (Misc queries) | |||
Database-Problems | Excel Discussion (Misc queries) | |||
problems using Excel as a mail merge database in Office XP | Excel Worksheet Functions | |||
Two problems sorting a database containing pictures | Excel Discussion (Misc queries) | |||
Two problems sorting a database containing pictures | Excel Discussion (Misc queries) |