I've been looking around, but without knowing the technical term for what I'm attempting I've struggled to find a solution.
here's an example.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Sheet 3
<tbody>
</tbody>
i need to combine them row by row but grouped by a common column (in this case c - a unique ID)
eg
sheet 4
<tbody>
</tbody>
this macro needs to loop until it reaches an empty row in sheet 1.
any suggestions as to what i'm attempting?
here's an example.
Sheet 1
column a | column b | column c | column d | column e |
00emp | 12345 | 29012019 | A12345 | |
00emp | 12346 | 29012019 | A12346 |
<tbody>
</tbody>
Sheet 2
column a | column b | column c | column d | column e |
10post | 12345 | London | A12345 | |
10post | 12346 | Manchester | A12346 |
<tbody>
</tbody>
Sheet 3
column a | column b | column c | column d | column e |
15person | 12345 | john doe | M | |
15person | 12346 | jane smith | F |
<tbody>
</tbody>
i need to combine them row by row but grouped by a common column (in this case c - a unique ID)
eg
sheet 4
column a | column b | column c | column d | column e |
00emp | 12345 | 29012019 | a12345 | |
10post | 12345 | London | a12345 | |
15person | 12345 | John Doe | M | |
00emp | 12346 | 29012019 | a12346 | |
10post | 12346 | Manchester | a12346 | |
15person | 12346 | Jane Smith | F |
<tbody>
</tbody>
this macro needs to loop until it reaches an empty row in sheet 1.
any suggestions as to what i'm attempting?