LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default 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. :)


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reverse value rb Excel Worksheet Functions 1 March 28th 07 02:51 AM
reverse value Mike Excel Worksheet Functions 0 March 28th 07 12:08 AM
Reverse worksheet data by columns Bruce Excel Worksheet Functions 3 July 12th 06 09:14 PM
Reverse Sum vjeevar Excel Discussion (Misc queries) 2 February 8th 06 10:04 PM
Reverse Worksheet John Wolfe Excel Discussion (Misc queries) 1 February 11th 05 03:17 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"