Sort Data in each section

[yukioh]

Hi All friends ans expert,

I would like to sort the data in table base on section as the sample attached,
but when i run macro " Sort data " in the sample file, it combined, how should i do?

[nilem]

Hi yukioh,
try it

Please Login or Register  to view this content.

[yukioh]

Hi nilem,
I have added your code, but the result is not arrange as attached file

[nilem]

Hi yukioh,
please try again

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[yukioh]

hi JOHN H. DAVIS
it still wrong arrange, how to do?

[JOHN H. DAVIS]

Can you provide a sample which shows a page before the sort, and a page after the sort?

[yukioh]

Hi JOHN H. DAVIS,

Here is the sample file before and after as attached file

[JOHN H. DAVIS]

Did you retry Nilems? It appears to do just as you wanted.

[yukioh]

Hi Nilem,
Yes, i have try Nilem's code, but the result is wrong with the header of the table,

can you try with this attached

[yukioh]

please some body help

[nilem]

Hi yukioh,
have you checked the file in the post #4?

[yukioh]

Hi nilem,
Thank you so much for your kindly help