VBA: Sort on two columns

[gio123bg]

Hi,
I have the necessity to execute a macro for sorting a list of data on two columns.
More exactly, let's suppose to have this situation:

A 10/2/2008 FFFF GGGG HHH
B 01/3/2008 PPPP LLLLL NNNN
B 12/4/2008 XXXX JJJJJ PPPP
B 08/1/2008 HHHH SSSS IIIII
C 15/10/2008 AAA BBBB CCC

I need this sort:
A 10/2/2008 FFFF GGGG HHH
B 08/1/2008 HHHH SSSS IIIII
B 01/3/2008 PPPP LLLLL NNNN
B 12/4/2008 XXXX JJJJJ PPPP
C 15/10/2008 AAA BBBB CCC

Any suggestion will be well appreciated.

Thanks in advance for your kind support.

Regars,

Giovanni

 

[stlockridge]

Great stuff! Would this flavor be possible with a macro?

Sort on column A (ascending alphabetically)
Sort on column N (custom value - i.e. EXTRA-SMALL, SMALL, MEDIUM, LARGE, EXTRA-LARGE, 2X, 3X...)

Thanks!

 

[Andrew Poulsom]

Welcome to MrExcel.

Have you created a custom list?

http://office.microsoft.com/en-us/e...for-sorting-and-filling-data-HA010222142.aspx

If so use the macro recorder to get the VBA code.

 

[stlockridge]

Sure haven't. I'm quite a novice with VB and advanced Excel.

Unfortunately I don't even really know where to start!

Thanks.

 

[stlockridge]

can I do this in 2003?

 

[zookeepertx]

Yes, you can! I have & I was so happy to discover it! If you go to Tools>Options & go to the Custom Lists tab, you can create a list of whatever words/numbers you want to search for, in whatever order you want it to search.

Jenny

 

[stlockridge]

OK, I found custom lists, and have one created, but don't know where to go from there. If I record a macro, how do I get it to sort column A ascending but then get it to do a secondary sort by the custom list?

 

[zookeepertx]

Edited to say - oops, just realized you want the SECONDARY sort by the custom list. I can't help you there, but am interested in the answer
Jenny

 

[Andrew Poulsom]

You will have to sort once on column N with the custom list as the primary key, then again on column A.

 

[zookeepertx]

Oh, of course; I knew that! It just escaped me for a bit! (If I was DOING it, I'd have remembered, but just talking about it isn't enough to jog my (poor worn-out) memory)
Sheesh, do I feel stupid NOW!

Jenny

 

[stlockridge]

Sorry for my stupidity, but how does one sort with the custom list?