+ Reply to Thread
Results 1 to 9 of 9

Macro to sort sheet based on header text in Row 1

  1. 04-01-2015, 07:57 AM #1
    nyree
    nyree is offline
    Registered User
    Join Date
    02-21-2013
    Location
    France
    MS-Off Ver
    Excel 2010
    Posts
    8

    Macro to sort sheet based on header text in Row 1

    Hello
    Can anyone help me with a macro to sort a sheet based on the text in the header, ie "Service".


    Many thanks in advance for your help

    Nyree
    Last edited by nyree; 04-01-2015 at 08:22 AM.
    Reply With QuoteRegister To Reply
  2. 04-01-2015, 08:03 AM #2
    JasperD
    JasperD is offline
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Macro to sort column based on header text in Row 1

    As far as I know, you can't sort a column based on a value.
    Do you mean you want to sort a sheet based on a column when the header is a certain value or word?
    Please click the * below if this helps
    Reply With QuoteRegister To Reply
  3. 04-01-2015, 08:08 AM #3
    nyree
    nyree is offline
    Registered User
    Join Date
    02-21-2013
    Location
    France
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Macro to sort column based on header text in Row 1

    Hello JaspeD
    Yes, my sheet has several columns and I want to always sort the column called "service", regardless of where it is in the sheet

    Thanks
    Nyree
    Reply With QuoteRegister To Reply
  4. 04-01-2015, 08:12 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to sort column based on header text in Row 1

    Just the column? Or the entire sheet based on the column?
    Reply With QuoteRegister To Reply
  5. 04-01-2015, 08:13 AM #5
    nyree
    nyree is offline
    Registered User
    Join Date
    02-21-2013
    Location
    France
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Macro to sort column based on header text in Row 1

    Hello John
    The entire sheet
    Reply With QuoteRegister To Reply
  6. 04-01-2015, 08:27 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to sort sheet based on header text in Row 1

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-01-2015, 08:28 AM #7
    JasperD
    JasperD is offline
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Macro to sort sheet based on header text in Row 1 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 04-01-2015, 08:36 AM #8
    nyree
    nyree is offline
    Registered User
    Join Date
    02-21-2013
    Location
    France
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Macro to sort sheet based on header text in Row 1

    Hello John
    That works perfectly!
    THANK YOU
    Reply With QuoteRegister To Reply
  9. 04-01-2015, 08:51 AM #9
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to sort sheet based on header text in Row 1

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. Review the link for guidance.

    http://www.excelforum.com/forum-rule...rum-rules.html
    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. [SOLVED] Rearrange(sort) Columns based on number in Column header string.
    By hifliers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 01:36 AM
  2. [SOLVED] I have a sort macro. How to add script to preselect rows to sort based on column value?
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2014, 02:25 AM
  3. Displaying column header text in a cell on each row, based on the value for that column
    By wmcandrew in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2014, 01:42 PM
  4. [SOLVED] Sort multiple columns based on column header
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 01-09-2013, 09:55 AM
  5. Delete column range based on header text
    By sunsoar77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2012, 07:45 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