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
[TABLE="class: grid, width: 496"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Date
[/TD]
[TD]Name
[/TD]
[TD]Doc 1[/TD]
[TD]Doc 2[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01111[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01111[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01111[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]bbbbbb[/TD]
[TD]01112[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]dddddd[/TD]
[TD]01113[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]bbbbbb[/TD]
[TD]01112[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]fffffff[/TD]
[TD]01114[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]gggggg[/TD]
[TD]01115[/TD]
[TD]02222[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]hhhhhh[/TD]
[TD]01119[/TD]
[TD]02223
[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD] [/TD]
[TD]02224[/TD]
[/TR]
[TR]
[TD]8-May-17[/TD]
[TD]cccccc[/TD]
[TD]01116[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8-May-17[/TD]
[TD]dddddd[/TD]
[TD]01117[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01116[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]iiiiiiii[/TD]
[TD]01118[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 372"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]No
[/TD]
[TD]Doc 1[/TD]
[TD]Doc 2[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]01111[/TD]
[TD] [/TD]
[TD]aaaaaa
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]01112[/TD]
[TD] [/TD]
[TD]bbbbbb[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01113[/TD]
[TD] [/TD]
[TD]dddddd[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]01114[/TD]
[TD] [/TD]
[TD]fffffff[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01115[/TD]
[TD]02222[/TD]
[TD]gggggg[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]01118[/TD]
[TD] [/TD]
[TD]iiiiiiii[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] [/TD]
[TD]02224[/TD]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]01119[/TD]
[TD]02223[/TD]
[TD]hhhhhh[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: grid, width: 496"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Date
[/TD]
[TD]Name
[/TD]
[TD]Doc 1[/TD]
[TD]Doc 2[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01111[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01111[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01111[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]bbbbbb[/TD]
[TD]01112[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]dddddd[/TD]
[TD]01113[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]bbbbbb[/TD]
[TD]01112[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]fffffff[/TD]
[TD]01114[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]gggggg[/TD]
[TD]01115[/TD]
[TD]02222[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]hhhhhh[/TD]
[TD]01119[/TD]
[TD]02223
[/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]aaaaaa[/TD]
[TD] [/TD]
[TD]02224[/TD]
[/TR]
[TR]
[TD]8-May-17[/TD]
[TD]cccccc[/TD]
[TD]01116[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8-May-17[/TD]
[TD]dddddd[/TD]
[TD]01117[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8-May-17[/TD]
[TD]aaaaaa[/TD]
[TD]01116[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7-May-17[/TD]
[TD]iiiiiiii[/TD]
[TD]01118[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 372"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]No
[/TD]
[TD]Doc 1[/TD]
[TD]Doc 2[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]01111[/TD]
[TD] [/TD]
[TD]aaaaaa
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]01112[/TD]
[TD] [/TD]
[TD]bbbbbb[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01113[/TD]
[TD] [/TD]
[TD]dddddd[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]01114[/TD]
[TD] [/TD]
[TD]fffffff[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01115[/TD]
[TD]02222[/TD]
[TD]gggggg[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]01118[/TD]
[TD] [/TD]
[TD]iiiiiiii[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] [/TD]
[TD]02224[/TD]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]01119[/TD]
[TD]02223[/TD]
[TD]hhhhhh[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]