Reversing a series in a range,

[srmorgan]

Got an assignment to enter two years worth of data into a file. Problem is my original file goes from 1/1/22 to 3/31/24 in ascending order left to right.
They want the dates going right to left with the current dates in the first column.
Range transpose won't work. I don't know how to use VBA so i need a simpler solution. Thanks srmorgan
S

Than


I

 

[Joe4]

How about Transpose the range (from columns to rows), sort in Descending order, and then Transpose back to columns?

 

[srmorgan]

that is a good idea i will have my colleague try that

Thanks

 

[Joe4]

You are welcome.

 

[srmorgan]

that is a good idea i will have my colleague try that

Thanks

That worked perfectly, thanks.

SRMorgan

 

[Alex Blakenburg]

Can't you just sort the columns Left to Right Descending (Newest to Oldest) ?

 

[Joe4]

Can't you just sort the columns Left to Right Descending (Newest to Oldest) ?

View attachment 109753

Oohhh!
That is cool! I never new that option existed!
Certainly would make things easier than having to Transpose twice.

 

[srmorgan]

Can't you just sort the columns Left to Right Descending (Newest to Oldest) ?

View attachment 109753

AS Joe said, i have never seen that option before. Thanks

 

[Alex Blakenburg]

It is a bit burried and doesn't get used very often.
@Joe4 - I have occassionally used it by putting =Match in the row above the column headings which then returns the order from a list or another table and used that to sort columns. It is very fast even on large datasets although my testing was on a sheet that doesn't have formulas.