+ Reply to Thread
Results 1 to 11 of 11

Reorder columns from shortest to longest

  1. 01-06-2015, 02:49 AM #1
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,779

    Reorder columns from shortest to longest

    Hello everybody
    I have in the attachment some columns which are different in height
    I want to reorder the columns by code and get the results in another sheet
    The desired results are illustrated in Sheet2
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-06-2015, 03:03 AM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Homeless. I am not kidding.
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,134

    Re: Reorder columns from shortest to longest

    Not sure if you need VBA for it. But you can insert a help row to count the total records, then go to Sort > Option > Sort by Rows
    Attached Files Attached Files
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 01-06-2015, 03:09 AM #3
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,779

    Re: Reorder columns from shortest to longest

    Thank you very much Mr. JieJenn

    I know that way ..But I need to do it by VBA
    Reply With QuoteRegister To Reply
  4. 01-06-2015, 03:46 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,648

    Re: Reorder columns from shortest to longest

    Try this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-06-2015, 04:00 AM #5
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,779

    Re: Reorder columns from shortest to longest

    Mr. jindon .. Really wonderful
    I can't express ny happiness with this awesome code.
    Just a little point
    I don't know how to get my results in sheet2
    Reply With QuoteRegister To Reply
  6. 01-06-2015, 04:01 AM #6
    karedog
    karedog is offline
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,788

    Re: Reorder columns from shortest to longest

    Hi,

    An alternative :

    Please Login or Register  to view this content.
    Regards
    Forum rules : http://www.excelforum.com/forum-rule...rum-rules.html
    Reply With QuoteRegister To Reply
  7. 01-06-2015, 04:04 AM #7
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,648

    Re: Reorder columns from shortest to longest

    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 01-06-2015, 04:17 AM #8
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,779

    Re: Reorder columns from shortest to longest

    Thanks a lot Mr. Jindon for this great help
    Mr. karedog I tested your code but got 1004 error at this line
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 01-06-2015, 04:42 AM #9
    karedog
    karedog is offline
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,788

    Re: Reorder columns from shortest to longest

    Sorry, previous code is for the range start on row 2 downward.

    Here is the new code :
    Please Login or Register  to view this content.
    Regards
    Reply With QuoteRegister To Reply
  10. 01-06-2015, 05:29 AM #10
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,779

    Re: Reorder columns from shortest to longest

    Thank you very much for all of you everybody
    Reply With QuoteRegister To Reply
  11. 01-06-2015, 08:22 AM #11
    karedog
    karedog is offline
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,788

    Re: Reorder columns from shortest to longest

    You are welcome, glad I can help.

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help - VBA to automatically reorder columns
    By jsabo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2013, 05:08 PM
  2. Excel 2007 : Excel 2007 Compare 2 Columns for inventory reorder levels
    By jeremylegasse in forum Excel General
    Replies: 4
    Last Post: 04-05-2011, 01:09 PM
  3. Excel 2007 : Reorder Columns Based On Column Order Of Another Worksheet
    By kordelle in forum Excel General
    Replies: 3
    Last Post: 06-16-2010, 04:23 PM
  4. shortest between 2 numbers
    By Martindelica in forum Excel General
    Replies: 4
    Last Post: 11-16-2007, 09:32 PM
  5. Longest Entry in Columns
    By Rebecca in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-26-2005, 12:07 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1