Sorting

[vincen1211]

I hv report in excel file as attached and want to make another report file sort in Dest(I), Date(K) and Type(L).
Due to Autofilter cannot working and copy-paste will be take long time, so please help building a macro for this problem.

The output should be like this :
I(Dest),K(Date),L(type), A,B,C,D(d1,d2),E(e1,e2..e4),F,G,H,J

Another problem is in colom A,B,C. As you see row 8-22, these colom are empty, because they're same type as row7.
While new report if sort base on Dest, these colom should be not be blank but must accordance to the upper data (row7).

Sorry for my bad english, hope you can understand .
Thank in advance .

[davesexcel]

Your example does not show the desired results.
Why does Auto Filter not work?

[vincen1211]

Because the report file contains not only table but also text and chart etc.
The file attached is example of some portion of the table.

The output result are base fm the table colom but I modified colom placement.

[vincen1211]

need help please...