Johnatha
02-29-2016, 12:54 PM
Hello!
I'm looking for a macro that will copy rows 1&2 of Sheet1, then paste (transpose) those rows on to a new sheet (Sheet2). Then, copy rows 1&3 and transpose to a new sheet (Sheet3). Then, copy rows 1&4 and transpose to a new sheet (Sheet4), and so on... Is this possible? I have 200 rows in total, and would hate to do this manually.
Candidate
Q1
Q2
Q3
Q4
Q5
Jim
y
z
1
2
3
Bill
x
x
x
x
x
Steve
u
u
u
u
u
Teeg
1
2
2
2
1
Jip
4
g
g
g
g
Thanks!! :)
I'm looking for a macro that will copy rows 1&2 of Sheet1, then paste (transpose) those rows on to a new sheet (Sheet2). Then, copy rows 1&3 and transpose to a new sheet (Sheet3). Then, copy rows 1&4 and transpose to a new sheet (Sheet4), and so on... Is this possible? I have 200 rows in total, and would hate to do this manually.
Candidate
Q1
Q2
Q3
Q4
Q5
Jim
y
z
1
2
3
Bill
x
x
x
x
x
Steve
u
u
u
u
u
Teeg
1
2
2
2
1
Jip
4
g
g
g
g
Thanks!! :)