Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting more than 3 columns - is it possible?
Hi there, can anyone tell me if its possible to sort by more than columns. I have 5 that i'd need to sort, but mmanually there is a limit of columns. I was hoping that with VBA I could include some more, but it doesn' seem to work... thanks in advance, Mat -- matp ----------------------------------------------------------------------- matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=52471 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting more than 3 columns - is it possible?
You can do this by sorting by the last two columns first, and then
by the first 3 - see http://support.microsoft.com/?kbid=268007 Andrew matpj wrote: Hi there, can anyone tell me if its possible to sort by more than 3 columns. I have 5 that i'd need to sort, but mmanually there is a limit of 3 columns. I was hoping that with VBA I could include some more, but it doesn't seem to work... thanks in advance, Matt -- matpj ------------------------------------------------------------------------ matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076 View this thread: http://www.excelforum.com/showthread...hreadid=524717 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freezing columns labels while sorting columns | New Users to Excel | |||
Sorting Columns | Excel Discussion (Misc queries) | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
sorting columns | Excel Programming | |||
sorting two columns together | Excel Worksheet Functions |