coliervile
Well-known Member
- Joined
- May 19, 2006
- Messages
- 724
I have some worksheets (named 1-8) that keep baseball statistics for each game played. I have other worksheets (named BLG1-GLB8) that are used as a baseball scorecard to keep score and statistics during the game. I want to link or transfer the statistics from the scorecard worksheet to the baseball statistic worksheet. Here are a few examples of the worksheets. It may take several messages to copy the worksheets so that you can get a clear picture of what I'm trying to do.
Best regards,
Charlie
Baseball Statistic Worksheet:
Baseball Scorecard Worksheet:
Best regards,
Charlie
Baseball Statistic Worksheet:
20080614 Tournament.xls | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
7 | |||||||||||||||||||||
8 | Player'sName | Hitting | BaseRunning | ||||||||||||||||||
9 | Hitter/Runner | G | PA | AB | H | RBI | 1B | 2B | 3B | HR | BB | HBP | SaF | SaB | K | R | SB | CS | LOB | ||
10 | Bradley,Colton | ||||||||||||||||||||
11 | Cantu,Alex | ||||||||||||||||||||
12 | Hamelink,Lucas | ||||||||||||||||||||
13 | Herson,Jake | ||||||||||||||||||||
1 |
Baseball Scorecard Worksheet:
20080614 Tournament.xls | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CJ | CK | CL | CM | CN | CO | CP | CQ | CR | CS | CT | CU | CV | CW | CX | CY | CZ | DA | DB | DC | |||
3 | GameTotals | Game# | 1 | 6 | 4 | |||||||||||||||||
4 | R | H | E | Date | 6/14/2008 | 1 | ||||||||||||||||
5 | 0 | 0 | 0 | Location | Jackson,MI | 5 | 3 | |||||||||||||||
6 | 0 | 0 | 0 | Opponent | EatonRapidsGreyhounds | |||||||||||||||||
7 | 2 | |||||||||||||||||||||
8 | IndividualGameTotals | |||||||||||||||||||||
9 | Hitting | BaseRunning | Fielding | |||||||||||||||||||
10 | PA | H | RBI | 1B | 2B | 3B | HR | BB | K | HBP | SaB | SaF | DI | R | SB | CS | LOB | Asst | PO | E | ||
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
12 | ||||||||||||||||||||||
13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
14 | ||||||||||||||||||||||
15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
16 | ||||||||||||||||||||||
17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
18 | ||||||||||||||||||||||
GLB1 |