Sort numeric data in more than 3 columns in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Addy - 22 Sep 2006 16:26 GMT

Hi All,

I have to sort 12 columns of numeric data in descending order on a
excel worksheet. I currently sort 3 at a time and then move forward.
For example, I have sales data for months Jan to Dec. I want each of
these columns to show zeros at the bottom when the macro is run. The
rows would increase in future but the columns would be fixed. The
worksheet would also remains unchanged each month. None of these
columns are of least significance.

Is there a way I could change a recorded macro to achieve this?? I know
very little of VB. This would be of great help!

Thanks!

Reply to this Message

Jim Cone - 22 Sep 2006 18:06 GMT

All of the columns will not necessarily show zeros/blanks at the bottom
as the overall sort order is determined by the last column sorted.
Or are you sorting each column independent of the other columns?

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Addy" <DASADITYA@gmail.com>
wrote in message
Hi All,
I have to sort 12 columns of numeric data in descending order on a
excel worksheet. I currently sort 3 at a time and then move forward.
For example, I have sales data for months Jan to Dec. I want each of
these columns to show zeros at the bottom when the macro is run. The
rows would increase in future but the columns would be fixed. The
worksheet would also remains unchanged each month. None of these
columns are of least significance.
Is there a way I could change a recorded macro to achieve this?? I know
very little of VB. This would be of great help!
Thanks!

Reply to this Message