How 2 reverse order of columns
 

I want to reverse the order of columns in a worksheet. Specifically, someone
has sent me a file of utility usage data in which the most recent date is in
column B and the oldest date is in column M. I want to reverse that, putting
the most recent date in M and the earliest in B. Is there a way to do this
without manually cutting and pasting?

Yes. DataSort, click Options, and then Left to Right, OK, Descending

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Bill Meacham" wrote in message
...
I want to reverse the order of columns in a worksheet. Specifically,
someone
has sent me a file of utility usage data in which the most recent date is
in
column B and the oldest date is in column M. I want to reverse that,
putting
the most recent date in M and the earliest in B. Is there a way to do
this
without manually cutting and pasting?

Great! Thanks!

"Niek Otten" wrote:

Yes. DataSort, click Options, and then Left to Right, OK, Descending

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Bill Meacham" wrote in message
...
I want to reverse the order of columns in a worksheet. Specifically,
someone
has sent me a file of utility usage data in which the most recent date is
in
column B and the oldest date is in column M. I want to reverse that,
putting
the most recent date in M and the earliest in B. Is there a way to do
this
without manually cutting and pasting?

Here's a small example:
*** Try this on a copy of your file, NOT The Original !! ***

WIth your dates (like you say) in a limited range, say B5:M50.

Drop down to the bottom of the worksheet and clear of the used area
where there's nothing below, say Row 105 and in cell
B105 enter =OFFSET($B5,0,13-COLUMN(),)
then copy and paste to cells C105:M105
then copy C105:M105 and paste to C106:M150

The dates now in C105:M150 will be what you want,
except their not where you want them; Highlight
C105:M150, Copy (it) then point to cell B5 and
do a Paste-Special Values. It may be necessary to
Format the Range B5:M50 to the desired date
format you want.

Hope this helps,,,
Jim May

"Niek Otten" wrote in message
...
Yes. DataSort, click Options, and then Left to Right, OK, Descending

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Bill Meacham" wrote in message
...
I want to reverse the order of columns in a worksheet. Specifically,
someone
has sent me a file of utility usage data in which the most recent date
is
in
column B and the oldest date is in column M. I want to reverse that,
putting
the most recent date in M and the earliest in B. Is there a way to do
this
without manually cutting and pasting?