sorting lardge amount of data
 

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?

--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida

sorting lardge amount of data
 

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.

"Lowell" wrote:

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?

--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida

sorting lardge amount of data
 

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.

--
Regards,
Fred


"Lowell" wrote in message
...
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?

--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida

sorting lardge amount of data
 

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...RC010801391033
4. Troubleshoot sorting

Challa Prabhu

"Lowell" wrote:

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?

--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida