reversing order of columns of data

Hi
This may be simple: I have a sheet that has the dates Jan 1 thru Dec 31 in
column A. Then in columns B on out I have years 1890 - 2005. I have the high
temps for each day in each of the years columns(Col B is 1890; Col C is
1891;etc.). I would like to reverse the order from 1890-2005 to 2005-1890.
(eg. Col B - 2005; Col C - 2004) What macro would work the best? Thanks,
Jim

select columns B to the last column. Then do

Data=>sort
Select options button and choose left to right.

Specify your row of dates as the key field (assume row 1)

--
Regards,
Tom Ogilvy

"Jim Brass" <[email protected]> wrote in message
news:[email protected]...
> Hi
> This may be simple: I have a sheet that has the dates Jan 1 thru Dec 31 in
> column A. Then in columns B on out I have years 1890 - 2005. I have the
high
> temps for each day in each of the years columns(Col B is 1890; Col C is
> 1891;etc.). I would like to reverse the order from 1890-2005 to 2005-1890.
> (eg. Col B - 2005; Col C - 2004) What macro would work the best? Thanks,
> Jim
>
>

Thanks! I never looked at the options button before. It worked slick!


*** Sent via Developersdex http://www.developersdex.com ***