Perhaps you mean ..
Assuming data to be added is within B1:B141
(ie you want:=B1+B15+B29+...+B141)
In say, C1:
=SUMPRODUCT(--(MOD(ROW(A1:A141)-1,14)=0),B1:B141)
Or perhaps you were hinting at something like this ..
In any starting cell, say in E2:
=IF(MOD(ROW(A1)-1,14)=0,"Std Msg","")
Copy E2 down as far as required to insert the phrase: Std Msg
in E2, E16, E30, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rob" wrote:
I am trying to add data every 14 rows up to a couple thousand rows. Is there
an easy way to do this?
--
radjr