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?
|