Sort numeric data in more than 3 columns in excel

A

Addy

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!
 
J

Jim Cone

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?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Addy" <[email protected]>
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!
 
Top