Hi,
I'm new to VBA and I know that this might be a big question, but here you go.
I have a sheet with data that look a bit like this and the columns continues with the next date:
<tbody>
</tbody>
I want this data to be copied in to a new sheet like this:
<tbody>
</tbody>
I can't figure out how to copy the first part of the row directly but 'split up' the other part. At least not in a 'simple' code.
I'm new to VBA and I know that this might be a big question, but here you go.
I have a sheet with data that look a bit like this and the columns continues with the next date:
A1 | B1 | C1 | D1 | E1 | F1 | G1 | |
Name | Info1 | Info2 | Info3 | Info4 | 12-09-2017 | 13-09-2017 | .... |
Simon | XX | XX | XX | XX | 1 | 2 | |
John | XX | XX | XX | XX | 2 | 1 |
<tbody>
</tbody>
I want this data to be copied in to a new sheet like this:
Name | Info1 | Info2 | Info3 | Info4 | Date | Data from that date |
Simon | XX | XX | XX | XX | 12-09-2017 | 1 |
Simon | XX | XX | XX | XX | 13-09-2017 | 2 |
John | XX | XX | XX | XX | 12-09-2017 | 2 |
John | XX | XX | XX | XX | 13-09-2017 | 1 |
<tbody>
</tbody>
I can't figure out how to copy the first part of the row directly but 'split up' the other part. At least not in a 'simple' code.