Hi,
I'm writing a small VBA code and now I'm stucked.
I have to say that I only have very little knowldedge about VBA.
However, I have an array in the following format:
H I J K L M
2 15 24 55 39 10
58 75 83 122 102
125 142 148 186 167
189 204 212 246 229
249 266 274 312 293
315 326 332 359 345
362 379 387 425 406
428 443 452 486 469
489 498 506 528 517
Cell M1 indicates that I have to export datasets to 10 new sheets (=number of rows, can vary between 10 and 50)
First step I want to do:
Copy range A(I1+1) : A(J1+I1-2) to new sheet(1) to location A1
Copy range A(J1+3) : A(K1-J1+5) to sheet(1) to location E1
Copy range A(K1-L1+4) : A(L1-i1-1)
Second step I want to do:
Repeat step 1 for all rows 2 to M1 and copy each set of data to a new sheet as well.
How should be my approach to master this task?
Any help is appreciated.
Cheers,
hegisin
Bookmarks