For cell K1 copy value every 30 rows down.

=IF(MOD(ROW(),30)=1,$K$1,"")

Comments are closed.