Sort numeric data in more than 3 columns in excel "Addy" <DASADITYA[ at ]gmail.com> 22.09.2006 15:26:35 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!

Re: Sort numeric data in more than 3 columns in excel "Jim Cone" <jim.coneXXX[ at ]rcn.comXXX> 22.09.2006 17:06:09 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" <DASADITYA[ at ]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!