+ Reply to Thread
Results 1 to 10 of 10

How to put order columns?

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    How to put order columns?

    Greetings,
    Following picture shows first situation;
    http://i.cubeupload.com/zFoS97.jpg
    Following picture shows what I need situation;
    http://i.cubeupload.com/wpqXUt.jpg

    How to put order columns?

    Please be aware that I have a lot of columns.

    Thanks in advance.
    Last edited by HerryMarkowitz; 03-25-2015 at 07:05 AM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: How to put order columns?

    If its just 3 Columns why not manually?
    Cheers!
    Deep Dave

  3. #3
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: How to put order columns?

    In yr worksheet and the active cell somewhere in the data range you want to sort:
    Select Data -> Sort
    Select Options and select "Sort left to right"
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to put order columns?

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to put order columns?

    Thanks Tsjallie.
    Thanks John.
    Solved.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to put order columns?

    You're welcome. Glad to help out.

  7. #7
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to put order columns?

    No, Not solved.
    I am refreshing my question;
    Following picture shows first situation;
    http://i.cubeupload.com/SeoysT.jpg
    Following picture shows what I need situation;
    http://i.cubeupload.com/jNFs10.jpg


    Please aware that I dont want sorting columns...
    I want to change columns places...

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to put order columns?

    What determines which Column goes where??

    Try:

    Please Login or Register  to view this content.

  9. #9
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: How to put order columns?

    I want to change columns places...
    Isn't that the same as sorting the columns?

    But if you can't sort based on row values, then you could add a marked to each column and sort on that.

  10. #10
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to put order columns?

    Thanks John. Solved.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort two columns (names) with keeping data intregity and order within the columns
    By ikindaknow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2015, 10:01 AM
  2. Replies: 7
    Last Post: 04-23-2014, 10:45 AM
  3. Replies: 0
    Last Post: 03-19-2013, 12:23 AM
  4. [SOLVED] Generate "ascending order no" for columns of data that are not in order
    By abreichenbach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-20-2013, 02:22 AM
  5. Listbox with multi-columns what determines the order of the columns?
    By jwright650 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2011, 03:43 PM

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