VBA: Sort on two columns

[gio123bg]

Hi,
I have the necessity to execute a macro for sorting a list of data on two columns.
More exactly, let's suppose to have this situation:

A 10/2/2008 FFFF GGGG HHH
B 01/3/2008 PPPP LLLLL NNNN
B 12/4/2008 XXXX JJJJJ PPPP
B 08/1/2008 HHHH SSSS IIIII
C 15/10/2008 AAA BBBB CCC

I need this sort:
A 10/2/2008 FFFF GGGG HHH
B 08/1/2008 HHHH SSSS IIIII
B 01/3/2008 PPPP LLLLL NNNN
B 12/4/2008 XXXX JJJJJ PPPP
C 15/10/2008 AAA BBBB CCC

Any suggestion will be well appreciated.

Thanks in advance for your kind support.

Regars,

Giovanni

 

[Makwa]

The issue here is to get the macro to automatically run this procedure on different spreadsheet , there are other procedures that run before this one to sort the data and they run perfectly ,how do i get the macro to also run this sort code/procedure without my interference?

The problem here is after sorting the data(adding headers, columns and separating text to numbers)i now want to sort the entire worksheet by "sales unit this year" then move to the last ACTIVE cell, then got to the next empty cell then put in that column and assign it to the data in column F then populate the data to the last cell that has data .

Repeat the above for the next worksheets ,taking notes on the dynamic number of worksheets and data on each worksheet



please see below

 

[Joe4]

The issue here is to get the macro to automatically run this procedure on different spreadsheet , there are other procedures that run before this one to sort the data and they run perfectly ,how do i get the macro to also run this sort code/procedure without my interference?

The problem here is after sorting the data(adding headers, columns and separating text to numbers)i now want to sort the entire worksheet by "sales unit this year" then move to the last ACTIVE cell, then got to the next empty cell then put in that column and assign it to the data in column F then populate the data to the last cell that has data .

Repeat the above for the next worksheets ,taking notes on the dynamic number of worksheets and data on each worksheet



please see below

Since your question is different from the original, it is better to post it to a breand new thread instead of posting it on a thread that is over 5 years old.
It will then show up on the "Unanswered threads" listing, and have a much better chance of being seen and receiving replies.