Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Iteration | Excel Worksheet Functions | |||
Iteration | Excel Programming | |||
iteration | Excel Discussion (Misc queries) | |||
Need help with iteration | Excel Discussion (Misc queries) | |||
Iteration | Excel Discussion (Misc queries) |