omegaboost
New Member
- Joined
- Nov 23, 2009
- Messages
- 1
Dear All,
I have the the table as shown in below which contain column Date, Name, Doc1, Doc2 and i have to make resume as shown in next table. In that Resume, the data sorted by date 7 May 2017 and should be shorted ascending and unique (no duplication).
Just wondering how to solve this matter by VBA?
Thank you
Best Regards
Omega Boost
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
I have the the table as shown in below which contain column Date, Name, Doc1, Doc2 and i have to make resume as shown in next table. In that Resume, the data sorted by date 7 May 2017 and should be shorted ascending and unique (no duplication).
Just wondering how to solve this matter by VBA?
Thank you
Best Regards
Omega Boost
| Date | Name | Doc 1 | Doc 2 |
| 7-May-17 | aaaaaa | 01111 | |
| 7-May-17 | aaaaaa | 01111 | |
| 7-May-17 | aaaaaa | 01111 | |
| 7-May-17 | bbbbbb | 01112 | |
| 7-May-17 | dddddd | 01113 | |
| 7-May-17 | bbbbbb | 01112 | |
| 7-May-17 | fffffff | 01114 | |
| 7-May-17 | gggggg | 01115 | 02222 |
| 7-May-17 | hhhhhh | 01119 | 02223 |
| 7-May-17 | aaaaaa | 02224 | |
| 8-May-17 | cccccc | 01116 | |
| 8-May-17 | dddddd | 01117 | |
| 8-May-17 | aaaaaa | 01116 | |
| 7-May-17 | iiiiiiii | 01118 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
| No | Doc 1 | Doc 2 | Name |
| 1 | 01111 | aaaaaa | |
| 2 | 01112 | bbbbbb | |
| 3 | 01113 | dddddd | |
| 4 | 01114 | fffffff | |
| 5 | 01115 | 02222 | gggggg |
| 6 | 01118 | iiiiiiii | |
| 7 | 02224 | aaaaaa | |
| 8 | 01119 | 02223 | hhhhhh |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
