ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I reverse the worksheet exactly the way it is? (https://www.excelbanter.com/setting-up-configuration-excel/138381-how-do-i-reverse-worksheet-exactly-way.html)

bnuphar

How do I reverse the worksheet exactly the way it is?
 
Ok so I want to reverse the worksheet in the exact order that it's already
in. Meaning I want the bottom row to become the top row and then the 2nd to
bottom row to become the 2nd row from the top. The first row is in date form
but for some reason it won't sort like that, it gets all mixed up.
There are 9 rows labeled:

Date, Type, To/From, Name/Email, Status, Gross, Fee, Net Amount, Balance

April 30, 2006, Payment, From, Cust. John Smith, Completed, $460.00 USD,
-$13.64 USD, $446.36 USD, $1,197.24 USD

it keeps going all the way to April 1, 2006 as the last row.

So how do I just flip this so April 1, 2006 is at the top and April 30, 2006
is at the bottom? I hope this makes sense. :)



DBex

How do I reverse the worksheet exactly the way it is?
 
Easy. Highlight all of the information (incl the headings) and sort the Date
column in Ascending order (Data, Sort, Sort By [Date]).

"bnuphar" wrote:

Ok so I want to reverse the worksheet in the exact order that it's already
in. Meaning I want the bottom row to become the top row and then the 2nd to
bottom row to become the 2nd row from the top. The first row is in date form
but for some reason it won't sort like that, it gets all mixed up.
There are 9 rows labeled:

Date, Type, To/From, Name/Email, Status, Gross, Fee, Net Amount, Balance

April 30, 2006, Payment, From, Cust. John Smith, Completed, $460.00 USD,
-$13.64 USD, $446.36 USD, $1,197.24 USD

it keeps going all the way to April 1, 2006 as the last row.

So how do I just flip this so April 1, 2006 is at the top and April 30, 2006
is at the bottom? I hope this makes sense. :)




All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com