Simple problem, difficult solution II

[Pericic]

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....

 

[PA HS Teacher]

I am not Russ, but you are welcome.

 

[Pericic]

My apologies,

Thanks PA, thanks a million