+ Reply to Thread
Results 1 to 11 of 11

Sort individual column Alphabetically

  1. 09-18-2015, 06:26 PM #1
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Sort individual column Alphabetically

    Hello:

    Please refer to attached file.
    I have lots of data in column B thru Column E
    I need an easy way either by VB Code or other mean to sort alphabetically the selected column form dropdown list in cell H2
    Let me know if you have any questions.
    Thanks.


    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-18-2015, 06:57 PM #2
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Sort individual column Alphabetically

    Hi Riz,


    Try this in your sheet module:

    Option Explicit

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by xladept; 09-18-2015 at 07:05 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 09-18-2015, 07:03 PM #3
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Sort individual column Alphabetically

    Hi,

    The attached is one way. It uses this Sheet Change macro

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  4. 09-18-2015, 07:07 PM #4
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Sort individual column Alphabetically 

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.
    Reply With QuoteRegister To Reply
  5. 09-18-2015, 07:29 PM #5
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Sort individual column Alphabetically

    Hi Richard and others :

    Thanks for your help.
    I beleive there is some misunderstanding.
    I will be choosing the column which needs to sorted alphabettically from drop down list in cell H2.
    Once selected, I need to only sort that particular selected column and leaving the other columns as it is.
    Please let me know if you have any questions.
    Thanks.

    Riz
    Reply With QuoteRegister To Reply
  6. 09-18-2015, 07:33 PM #6
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Sort individual column Alphabetically

    or with CheckBox instead of validation


    Kind regards
    Leo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 09-18-2015, 07:34 PM #7
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Sort individual column Alphabetically

    Hi Riz,

    I'm under the impression that my code does exactly what you've described
    Reply With QuoteRegister To Reply
  8. 09-18-2015, 07:54 PM #8
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Sort individual column Alphabetically

    Hello:

    xladept : For some reason it is not doing any thing at my end.
    LeoTaxi : Your code works great

    Thanks to All

    Riz
    Reply With QuoteRegister To Reply
  9. 09-18-2015, 09:02 PM #9
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Sort individual column Alphabetically

    Hi xladept:

    Your code works great.
    It was my mistake of pasting the code in Modeul1 instead of Sheet1
    Sorry and once again thank u so much for such a great help
    Riz
    Reply With QuoteRegister To Reply
  10. 09-18-2015, 09:21 PM #10
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Sort individual column Alphabetically

    Hi Riz,

    You're welcome and thanks for the rep!

    I'm so pleased that it worked out.

    Orrin
    Reply With QuoteRegister To Reply
  11. 09-19-2015, 05:40 AM #11
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Sort individual column Alphabetically

    Quote Originally Posted by rizmomin View Post
    Hi Richard and others :

    Thanks for your help.
    I beleive there is some misunderstanding.
    I will be choosing the column which needs to sorted alphabettically from drop down list in cell H2.
    Once selected, I need to only sort that particular selected column and leaving the other columns as it is.
    Please let me know if you have any questions.
    Thanks.

    Riz
    Hi Riz,

    I don't understand your concern. The macro I gave you does react to the drop down selection and sort accordingly. Did you open the file I attached and try it?
    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. Sort Alphabetically
    By Bob@Sun in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-23-2015, 10:18 AM
  2. Macro to Sort column B and C alphabetically
    By anthony.maddick in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2014, 09:27 PM
  3. Sort Alphabetically letters and numbers(column) - sorted letters on the top in the column
    By Ferddy in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-27-2014, 11:05 AM
  4. Sort Alphabetically each 6th row
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2013, 03:15 PM
  5. Is it possible to pull out one column and sort alphabetically from a "Table"?
    By Skylark in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2010, 10:15 PM
  6. sort alphabetically and numerically, then sort rows
    By luke20allen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-01-2008, 07:00 AM
  7. excel to sort data in a column alphabetically
    By zachmcnulty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2008, 12:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1