Remove formula, copy range & Insert formula

[hsandeep]

My range is C2:AL12
There are 6 cells C2; I2; O2; U2; AA2 & AG2 which generates values.
Another 6 cells (below the above cells) C3; I3; O3; U3; AA3 & AG3 HasFormula & generates values.
Now, exactly 6 rows below C2 (i.e. C8) AND up to exactly 10 rows below C2 (i.e. C12) HasFormula & generates values of [R1C1] type like in C8=D8 & so on up to C12=D12.
Similarly for I2; O2; U2; AA2 & AG2; exactly 6 rows below I2 (i.e. I8) AND up to exactly 10 rows below I2 (i.e. I12) HasFormula & generates values of [R1C1] type like in I8=J8 & so on up to I12=J12 & so on till AG2.
There is a ‘control cell’ A4 which generates values & keeps on changing.

I need a Worksheet code which should perform the following actions:

If C2<=$A$4 then REMOVE THE FORMULAS from C3 AND ALSO FROM C8:C12 & so on till AG2.

Multiple IFs_1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
2			30						35						40						45						50						55
3			30						35						40						45						50						55
4	51
5	30
6
7
8			50	50					58	58					999	999					888	888					777	777					666	666
9			32	32					45	45					444	444					400	400					62	62					550	550
10			11	11					21	21					333	333					300	300					45	45					450	450
11			78	78					11	11					222	222					200	200					22	22					350	350
12			42	42					1	1					111	111					100	100					15	15					250	250
13
14	100
15	99
16	100
17	99
T2

Cell Formulas
Range	Formula
C2	C2	=A5
C3,AG3,AA3,U3,O3,I3	C3	=C2
I2,AG2,AA2,U2,O2	I2	=C2+5
AG8:AG12,AA8:AA12,U8:U12,O8:O12,I8:I12,C8:C12	C8	=D8
A14:A15	A14	=A16

Fill C2:AG2 with MATCHED C2:AG2 (this happens if A5 gets changed). AND ALSO FILL exactly 6 rows below C2 (i.e. C8) AND up to exactly 10 rows below C2 (i.e. C12) which now does not HasFormula with the MATCHED C2:AG2 with the values of C8:C12 & so on.

Multiple IFs_1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
2			15						20						25						30						35						40
3			15						20						25						30						35						40
4	38																				MATCHED						MATCHED						MATCHED
5	15
6
7
8			50	50					58	58					999	999					50	888					58	777					999	666
9			32	32					45	45					444	444					32	400					45	62					444	550
10			11	11					21	21					333	333					11	300					21	45					333	450
11			78	78					11	11					222	222					78	200					11	22					222	350
12			42	42					1	1					111	111					42	100					1	15					111	250
13
14	100
15	99
16	100
17	99
T3

Cell Formulas
Range	Formula
C2	C2	=A5
I2,AG2,AA2,U2,O2	I2	=C2+5
A14:A15	A14	=A16

If A15>=A17, then INSERT THE FORMULA BACK in C2:AG2 as C2=C1 & son on till AG2=AG1 AND ALSO INSERT THE FORMULA BACK in C8:C12 as C8=D8 & C12=D12 & so on till AG8=AH8 & AG12=AH12 of [R1C1] type.

Multiple IFs_1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
2			15						20						25						30						35						40
3			15						20						25						30						35						40
4	44
5	15
6
7
8			50	50					58	58					999	999					888	888					777	777					666	666
9			32	32					45	45					444	444					400	400					62	62					550	550
10			11	11					21	21					333	333					300	300					45	45					450	450
11			78	78					11	11					222	222					200	200					22	22					350	350
12			42	42					1	1					111	111					100	100					15	15					250	250
13
14	100
15	100
16	100
17	100
T4

Cell Formulas
Range	Formula
C2	C2	=A5
C3,AG3,AA3,U3,O3,I3	C3	=C2
I2,AG2,AA2,U2,O2	I2	=C2+5
AG8:AG12,AA8:AA12,U8:U12,O8:O12,I8:I12,C8:C12	C8	=D8
A14:A15	A14	=A16

How to achieve this?

 

[hsandeep]

2 typo errors in above thread:
Fill C3:AG3 with MATCHED C2:AG2 instead of Fill C2:AG2 with MATCHED C2:AG2
If A15>=A17, then INSERT THE FORMULA BACK in C3:AG3 as C3=C2 & son on till AG3=AG2 instead of If A15>=A17, then INSERT THE FORMULA BACK in C2:AG2 as C2=C1 & son on till AG2=AG1