How 2 reverse order of columns

[Bill Meacham]

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?

[Niek Otten]

Yes. Data>Sort, click Options, and then Left to Right, OK, Descending

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Bill Meacham" <[email protected]> wrote in message
news:[email protected]...
>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?

[Bill Meacham]

Great! Thanks!

"Niek Otten" wrote:

> Yes. Data>Sort, click Options, and then Left to Right, OK, Descending
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Bill Meacham" <[email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>

[Jim May]

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" <[email protected]> wrote in message
news:[email protected]...
> Yes. Data>Sort, click Options, and then Left to Right, OK, Descending
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Bill Meacham" <[email protected]> wrote in message
> news:[email protected]...
> >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?
>
>