answers.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | M | N | |||
7 | TABLE A: Schedule - Scores | TABLE B: Database | ||||||||||||
8 | Weeek | Team A | Score | Team B | Score | Team | PF | PA | Games | Avg PF | Avg PA | |||
9 | 1 | NewEngland | 21 | Denver | 24 | NewEngland | 21 | 24 | 1 | 21.0 | 24.0 | |||
10 | Indianapolis | 24 | Atlanta | 21 | Indianapolis | 24 | 21 | 1 | 24.0 | 21.0 | ||||
11 | Pittsburgh | 27 | Philadelphia | 21 | Pittsburgh | 27 | 21 | 1 | 27.0 | 21.0 | ||||
12 | 2 | Denver | Indianapolis | Philadelphia | 21 | 27 | 1 | 21.0 | 27.0 | |||||
13 | Atlanta | Philadelphia | Atlanta | 21 | 24 | 1 | 21.0 | 24.0 | ||||||
14 | Pittsburgh | NewEngland | Denver | 24 | 21 | 1 | 24.0 | 21.0 | ||||||
15 | ||||||||||||||
16 | TABLE C: Predictions | |||||||||||||
17 | Weeek | Team A | p/s | Team B | p/s | |||||||||
18 | 2 | Denver | 22.5 | Indianapolis | 22.5 | |||||||||
19 | Atlanta | 24 | Philadelphia | 22.5 | ||||||||||
20 | Pittsburgh | 25.5 | NewEngland | 21 | ||||||||||
Sheet2 |
This is a much better presentation of my real problem..
Table A is input data (entered manually)
Table B uses table A's data
Table C uses table B's data..
How can I prevent Table C's data from changing (or take a snapshot of it before it changes) when I enter week 2 scores (i.e., preserve the predictions for week 2 which are based only on week 1 scores; preserve week 3 predictions - based on week 1 and 2 scores; preserve week 4 predictions - based on week 1, 2, and 3 scores, and so on.......
I need this to be done automatically (no copy-paste special- values only) because my real data has thousands of rows...
For the last 2 years I have been searching the internet for the answer...
Thank you so much guys for your efforts....