+ Reply to Thread
Results 1 to 7 of 7

Sorting a range to invert it upside down without sorting by any specific column

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Sorting a range to invert it upside down without sorting by any specific column

    I have a bunch of data in A1:D20. Is it possible to sort it with VB without using any particular column in the worsheet to sort it by so that the data basically turns upside down. That is - row 1 data now appears in row 20, row 2 data in row 19, row 3 in row 18 and so on? I'm looking to do this without adding an additional column and numbering it 1:20, then sorting it by that column.

    Thank you
    Last edited by luv2glyd; 03-29-2013 at 12:53 PM.
    You either quit or become really good at it. There are no other choices.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Sorting a range to invert it upside down without sorting by any specific column

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Sorting a range to invert it upside down without sorting by any specific column

    Is this same question?

    http://www.excelforum.com/excel-form...ic-column.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: Sorting a range to invert it upside down without sorting by any specific column

    Mick,

    That works great! Thank you!

  5. #5
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: Sorting a range to invert it upside down without sorting by any specific column

    Fotis - yes and no - I wanted to learn how to do it with and without VBA as I have different applications for each method.

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Sorting a range to invert it upside down without sorting by any specific column

    PLs be carefull when you do this, because in fact it's a duplicate thread. It's better to make a notice that you would like suggestions for both ways.

  7. #7
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: Sorting a range to invert it upside down without sorting by any specific column

    Mick (or anyone else that has any advice),

    Your code below works great for when my data starts in cell A1, though that's not always the case - C4, R22, T90 you name it. I tried tweaking it to make it work, but never seem to get it to do the operation correctly. Any advice?

    Please Login or Register  to view this content.
    Thanks.

    Fotis, no problem - will do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1