vbid
06-21-2017, 07:47 PM
Hi everyone,
I need help with a code that requires a loop. Basically I need help with copying the values from sheet 1 (1 row) to sheet 2 which will generate an output on sheet 3(same format as sheet 2). I would then need to copy the output from sheet 3 back to sheet 1. However the problem is that i would require to repeat this process for multiple rows on sheet 1. Would require some help with this.
Attached is an attachment for the example that i would require. Thanks in advance!
Sheet 1
a1 b1 c1 d1 e1 f1 .... aa1 ab1 ac1 ... aa1* ab1* ac1*
a2 b2 c2 d2 e2 f2 .... aa1 ab1 ac1
Sheet 2
a1 b1 c1
d1 e1 f1
. . .
aa1 ab1 ac1
sheet 3
a1* b1* c1*
d1* e1* f1*
...
aa1* ab1* ac1*
I need help with a code that requires a loop. Basically I need help with copying the values from sheet 1 (1 row) to sheet 2 which will generate an output on sheet 3(same format as sheet 2). I would then need to copy the output from sheet 3 back to sheet 1. However the problem is that i would require to repeat this process for multiple rows on sheet 1. Would require some help with this.
Attached is an attachment for the example that i would require. Thanks in advance!
Sheet 1
a1 b1 c1 d1 e1 f1 .... aa1 ab1 ac1 ... aa1* ab1* ac1*
a2 b2 c2 d2 e2 f2 .... aa1 ab1 ac1
Sheet 2
a1 b1 c1
d1 e1 f1
. . .
aa1 ab1 ac1
sheet 3
a1* b1* c1*
d1* e1* f1*
...
aa1* ab1* ac1*