VBA loop copy formulas and conditions based on rows

[KoskeKos]

Hi to all.

Got 1 problem(for now ) cant figure it out.

1. got row data on the left side (filled rows)
2. if row (column A4) is not empty > copy row (formulas and conditions) F1 (from column BJ to GK) behind (after BI column)
3. loop till last row.

Would be grateful.

 

[KoskeKos]

Hi.
Just found this addon
IF X rows are populated, copy first row X times (blue with zeros starting from column SEC to column OI)
Rows are dynamic.
Thanks in advance.

DATE	CLIENT ID																																																												SEC	HR	EE	ED	CC	SMR	SMC	ST	CG	RG	PS	MB	IO	IN	CO	RE	OI
Date	ID_Client																																																												CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC	CALC
																																																													0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
31/03/2022	1608953215030
31/03/2022	1207971210262
31/03/2022	1009982255016
31/03/2022	0605986254993
31/03/2022	2401984250012