sorting lardge amount of data

[Guest]

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?

 

[Guest]

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.

 

[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.

 

[Guest]

Hi,

See the following sections in the on-line help:

1. Sort a range
2. Sort a PivotTable or PivotChart report
3. http://office.microsoft.com/training/training.aspx?AssetID=RC010801391033
4. Troubleshoot sorting

Challa Prabhu