Hi All,
This should be easy but its not! I am wanting a VBA loop script.
1. which goes down column A and check if there are codes that are the same e.g below the first 4 are the same.
2. from this am wanting to create a new table which copies the code 000000HA once and then the 4 dates after in columns like this:
E F G H I
000000HA 26/02/2014 07/08/2014 13/08/2013 18/08/2014
A B C
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Can any one help?
This should be easy but its not! I am wanting a VBA loop script.
1. which goes down column A and check if there are codes that are the same e.g below the first 4 are the same.
2. from this am wanting to create a new table which copies the code 000000HA once and then the 4 dates after in columns like this:
E F G H I
000000HA 26/02/2014 07/08/2014 13/08/2013 18/08/2014
A B C
000000HA | 665587 | 13/08/2014 |
000000HB | 529853 | 26/02/2014 |
000000HB | 659642 | 07/08/2014 |
000000HB | 668763 | 18/08/2014 |
000000I5 | 554083 | 31/03/2014 |
000000IU | 656913 | 04/08/2014 |
000000KL | 500644 | 22/01/2014 |
000000LN | 560331 | 07/04/2014 |
000000LN | 652808 | 30/07/2014 |
000000LZ | 640351 | 15/07/2014 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Can any one help?