Custom Data Sort
 

"Jim" wrote in message news:...
Hi:
I need to sort several columns based upon a binary sort of a column of
data.
It will not sort binary on the worksheet.
I have procedures that parse out the data character by character into
arrays
and sort it. My problem is that I don't know
how to call the custom sort from a custom toolbar button. Unless Excel's
Sort Method can do what I need it to do, I need
to sort the data column using my procedures and apply the sort to a range
of
several columns.


(Please disregard the formatting if it's messed up.)

Befo After: (ie binary sort)
a1000000 0000123
350a23.155 1
350a23.15 100
350a23.123 1000
350a23.11 1000000000001
350a23.101 11
350a23.100 111
350a23.10 1111
350a20.1555 12
1000000000001 14
0000123 2
1111 350a20.1555
1000 350a23.10
111 350a23.100
100 350a23.101
14 350a23.11
12 350a23.123
11 350a23.15
2 350a23.155
1 a1000000


Thanks in advance.
Jim

Custom Data Sort
 

Got it.

"Jim" wrote in message
news:6%VTb.398998$ts4.360988@pd7tw3no...

"Jim" wrote in message news:...
Hi:
I need to sort several columns based upon a binary sort of a column of
data.
It will not sort binary on the worksheet.
I have procedures that parse out the data character by character into
arrays
and sort it. My problem is that I don't know
how to call the custom sort from a custom toolbar button. Unless Excel's
Sort Method can do what I need it to do, I need
to sort the data column using my procedures and apply the sort to a range
of
several columns.


(Please disregard the formatting if it's messed up.)

Befo After: (ie binary sort)
a1000000 0000123
350a23.155 1
350a23.15 100
350a23.123 1000
350a23.11 1000000000001
350a23.101 11
350a23.100 111
350a23.10 1111
350a20.1555 12
1000000000001 14
0000123 2
1111 350a20.1555
1000 350a23.10
111 350a23.100
100 350a23.101
14 350a23.11
12 350a23.123
11 350a23.15
2 350a23.155
1 a1000000


Thanks in advance.
Jim