Update Cells weekly

[gillmit]

Hi



I am stuck and need some help please. I have attached a image of the work i am doing. I am looking to update each cell down weekly from information from another cell when it is updated i do this every Tuesday.



Example

---------

so C4 is 2.15% that i have put in myself. Id then like C88 to auto update once i have inputted the data in C4. Then say on the 09/07/2024 next Tuesday the percentage is say 2.75% it will only change the information in C89.





Id like the same solution for C5 C6 C7 ETC marrying to the corresponding information attached







Any help would be much appreciated please



Thank you

 

[gillmit]

excel help (1).xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
3
4	1	2.15%	10	2.20%
5	2	1.65%	11	2.55%
6	3	4.75%	12	4.50%
7	4	1.55%	13	3.90%
8	5	1.44%	14	1.44%
9	6	0.90%	15	1.20%
10	7		16
11	8	1.75%	17	1.75%
12	9	4.50%	18	4.50%
13
14
15
16	Date	1	Pass through % since last rate change	2	Pass through % since last rate change	3	Pass through % since last rate change	4	Pass through % since last rate change	5	Pass through % since last rate change	6	Pass through % since last rate change	8	Pass through % since last rate change	9	Pass through % since last rate change
17	04/06/2024	1.20%		0.65%				0.40%		0.75%		0.77%		1.25%
18	11/06/2024	1.50%	60%	0.75%	20%		0%	0.65%	50%	0.75%	0%	0.77%		1.50%			0%
19	18/06/2024	1.50%	0%	0.75%	0%		0%	0.65%	0%	0.75%	0%	0.77%		1.75%			0%
20	25/06/2024	1.50%	0%	0.75%	0%		0%	0.65%	0%	0.75%	0%	0.77%		1.75%			0%
21	02/07/2024							0.65%
22	09/07/2024	1.80%	60%	0.85%	20%		0%	0.65%	0%	1.09%	68%	0.77%		1.75%			0%
23	16/07/2024	1.80%	0%	0.85%	0%		0%	0.65%	0%	1.09%	0%	0.77%		1.75%			0%
Instant Saver

Cell Formulas
Range	Formula
C4	C4	=LOOKUP(2,1/((C17:C114)<>""),C17:C114)
C5	C5	=LOOKUP(2,1/((E17:E114)<>""),E17:E114)
C6	C6	=LOOKUP(2,1/((G17:G114)<>""),G17:G114)
C7	C7	=LOOKUP(2,1/((I17:I114)<>""),I17:I114)
C8	C8	=LOOKUP(2,1/((K17:K114)<>""),K17:K114)
C9	C9	=LOOKUP(2,1/((M17:M114)<>""),M17:M114)
E4	E4	=LOOKUP(2,1/((C156:C262)<>""),C156:C262)
E5	E5	=LOOKUP(2,1/((E156:E262)<>""),E156:E262)
E6	E6	=LOOKUP(2,1/((G156:G262)<>""),G156:G262)
E7	E7	=LOOKUP(2,1/((I156:I262)<>""),I156:I262)
E8	E8	=LOOKUP(2,1/((K156:K262)<>""),K156:K262)
E9	E9	=LOOKUP(2,1/((M156:M262)<>""),M156:M262)
C11	C11	=LOOKUP(2,1/((O17:O114)<>""),O17:O114)
C12	C12	=LOOKUP(2,1/((Q17:Q114)<>""),Q17:Q114)
E11	E11	=LOOKUP(2,1/((O156:O262)<>""),O156:O262)
E12	E12	=LOOKUP(2,1/((Q156:Q262)<>""),Q156:Q262)
R18	R18	=IF(S18=0,((Q18-$Q$17)/$S$17)," ")
R19	R19	=IF(S19=0,((Q19-$Q$18)/$S$17)," ")
R20	R20	=IF(S20=0,((Q20-$Q$19)/$S$17)," ")
R21	R21	=IF(S21=0,((Q21-$Q$156)/$S$156)," ")
R22:R23	R22	=IF(S22=0,((Q22-$Q$21)/$S$21)," ")
D18	D18	=IF(S18=0,((C18-$C$17)/$S$17)," ")
D19	D19	=IF(S19=0,((C19-$C$18)/$S$17)," ")
D20	D20	=IF(S20=0,((C20-$C$19)/$S$17)," ")
F18	F18	=IF(S18=0,((E18-$E$17)/$S$17)," ")
F19	F19	=IF(S19=0,((E19-$E$18)/$S$17)," ")
F20	F20	=IF(S20=0,((E20-$E$19)/$S$17)," ")
H18	H18	=IF(S18=0,((G18-$G$17)/$S$17)," ")
H19	H19	=IF(S19=0,((G19-$G$18)/$S$17)," ")
H20	H20	=IF(S20=0,((G20-$G$19)/$S$17)," ")
J18	J18	=IF(S18=0,((I18-$I$17)/$S$17)," ")
J19	J19	=IF(S19=0,((I19-$I$18)/$S$17)," ")
J20	J20	=IF(S20=0,((I20-$I$19)/$S$17)," ")
L18	L18	=IF(S18=0,((K18-$K$17)/$S$17)," ")
L19	L19	=IF(S19=0,((K19-$K$18)/$S$17)," ")
L20	L20	=IF(S20=0,((K20-$K$19)/$S$17)," ")
I21	I21	=I20
D22	D22	=IF(S22=0,((C22-$C$20)/$S$21)," ")
D23	D23	=IF(S23=0,((C23-$C$22)/$S$21)," ")
F22	F22	=IF(S22=0,((E22-$E$20)/$S$21)," ")
F23	F23	=IF(S23=0,((E23-$E$22)/$S$21)," ")
H22	H22	=IF(S22=0,((G22-$G$20)/$S$21)," ")
H23	H23	=IF(S23=0,((G23-$G$22)/$S$21)," ")
J22	J22	=IF(S22=0,((I22-$I$20)/$S$21)," ")
J23	J23	=IF(S23=0,((I23-$I$22)/$S$21)," ")
L22	L22	=IF(S22=0,((K22-$K$20)/$S$21)," ")
L23	L23	=IF(S23=0,((K23-$K$22)/$S$21)," ")