sorting lardge amount of data

L

Lowell

Hello,
I have a spread sheet with several columns ( about 300) of date and the
needs to be sorted example:


A B C D E F
1 Date Date Date Date Date Date
2 310 710 230 1468 2001 672
3 222 111 2133 28 1453 772
4 67 2573 2 369 543 3

Is there an easy way to sort all of these at the same time to get he columns
to arrange the numbers from low to high?
 
O

oli merge

hi, cant tell u the exact code but have you tried something like a "for" loop
with the column name as a variable and the loop itself consisting of a simple
sort?

not sure how to increment alphabetically rather than numerically tho, but im
sure someone here will.
 
F

Fred Smith

You could create a macro to do this. It would work along the lines of:

For i = 1 to #columns
columns(i).select
selection.sort ...
next i

If you need more help, post to the .programming group. They can give you the
specifics.
 
Top