Hi All,

In excel we can sort max 3 columns data but can we sort multiple columns through vba code at one go. If yes, can you please provide an example


Thanks for your help in advance.

I don't think you can sort more than 3 columns at a time, but one way round this is to concatenate columns. It depends what data you have.

If entries in a particular column are all the same length then great, but if the data is of variable length then you will need to add something to make them a consistent length. For numeric data, just add the value to a fixed big number (say 10000000, because then it is easy to read).

For text data you need to add a series of spaces. One way to do this is:

=(A1 & left(" ",(50-len(A1)))

where A1 is the text data and there are 50 spaces between the inverted commas.

Hope you can make something of this suggestion.

Thanks,
Caspar

In Excel 2007 you can sort as many columns as you like. In prior versions, do this:

If you want to sort columns in the order A, C, F, B, I,

Split your columns into groups of three, from the start.

Group 1 = A, C, F
Group 2 = B, I

Then sort each group in reverse order. So, do the sort on group 2 first, then group 1.

Here is a link to a knowledge base article saying the same thing:
How to sort more than three columns in Excel