oliverraaijmakers
New Member
- Joined
- Jun 25, 2012
- Messages
- 3
I am looking for a macro (no pivottable) that can combine data from 2 sheets (5 columns and 2columns) into 1 additional sheet in such a way that for every 1 row in the first sheet, all rows in the second sheet get copied below eachother in the third sheet (in 2 seperate colums). The problem is that the amount of rows in both sheets can vary. So it should work with 2 row entries, but also with 20; in both sheets.
Example:
sheet 1:
R1:
1
2
3
sheet 2:
R1:
a
b
c
d
this should result in
sheet 3:
R1 R2
1 a
1 b
1 c
1 d
2 a
2 b
2 c
2 d
3 a
3 b
3 c
3 d
thank you in advance
Example:
sheet 1:
R1:
1
2
3
sheet 2:
R1:
a
b
c
d
this should result in
sheet 3:
R1 R2
1 a
1 b
1 c
1 d
2 a
2 b
2 c
2 d
3 a
3 b
3 c
3 d
thank you in advance
