Day: April 30, 2016

For cell K1 copy value every 30 rows down.

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