C
CompleteNewb
I'm compiling data and writing it to a new sheet; it's a varying number of
rows each time I run the procedure, but for every procedure it's the same
number of rows. So, for instance, this time my data fills 7 rows (From A1
to A7 is a one-time 1-column only header-type column), then my loop fills
B-D, then E-G, etc.). I need to go down and start at A9 after my data
filling loops reaches 3 iterations. So if there are 12 sets of data I'm
looping through (this could change), I need to put set 1 in B-D, set 2 in
E-G, set 3 in H-J, then, because I've done 3 iterations, go down to A9, fill
A-C, D-F, H-I, now that's 3 iterations again, so I need to go down to A-16,
etc.
I tried using 2 dependent counters, where one goes up one for every
iteration, then the other goes up one when the first one has gone up 2, but
it's not working, and I think my logic is flawed as well.
Can someone suggest a good way to do this?
Thanks for your help.
rows each time I run the procedure, but for every procedure it's the same
number of rows. So, for instance, this time my data fills 7 rows (From A1
to A7 is a one-time 1-column only header-type column), then my loop fills
B-D, then E-G, etc.). I need to go down and start at A9 after my data
filling loops reaches 3 iterations. So if there are 12 sets of data I'm
looping through (this could change), I need to put set 1 in B-D, set 2 in
E-G, set 3 in H-J, then, because I've done 3 iterations, go down to A9, fill
A-C, D-F, H-I, now that's 3 iterations again, so I need to go down to A-16,
etc.
I tried using 2 dependent counters, where one goes up one for every
iteration, then the other goes up one when the first one has gone up 2, but
it's not working, and I think my logic is flawed as well.
Can someone suggest a good way to do this?
Thanks for your help.