fixed interval sampling

[Piers Clinton-Tarestad]

does anyone know where I can get some sample code on fixed interval
sampling?
I'm looking to design a macro which will basically sample some data and put
the sample in a separate sheet
cheers
Piers

 

[Tom Ogilvy]

j = 1
for i = 20 to 2000 step 200
cells(i,"A").EntireRow.copy Destination:=activesheet.next.Cells(j,A")
j = j + 1
Next

 

[Piers Clinton-Tarestad]

tom thats really useful
the only thing is i want the interval to be based on the cumlative total of
a column

for example if the cells contain the following numbers

a1-5
a2-10
a3-5
a4-6

and the interval is 10 i want it to pick a2 as 10 is reached by adding a1
and a2 and then to pick a3 as there is 5 left over from a1 and a2 and this
with a3 gives the next 10

doubt this makes any sense but hey!