PDA

View Full Version : VBA copy paste looping help



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*

vbid
06-21-2017, 07:57 PM
To prevent confusion,

the results should look like this

Sheet 1
a1 b1 c1 d1 e1 f1 .... aa1 ab1 ac1 ... a1* b1* c1* d1* e1* f1* ... 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*

vbid
06-21-2017, 08:25 PM
Sheet 3 has formulas referenced to sheet 2. Basically the example stated on the first post is for 1 row of values. I would require a formula that copy pastes multiple rows of formula from sheet 1 to sheet 2 (Replacing cells previously pasted on to). This will generate a set of results on sheet 3 which i would need to copy back to sheet 1 on a new column but same row.