Excel: Tips April 30, 2016 5:07 pm \ by John Perry For cell K1 copy value every 30 rows down. =IF(MOD(ROW(),30)=1,$K$1,"") Posted in: Excel