+ Reply to Thread
Results 1 to 5 of 5

Sort all workbook tabs after the Summary Tab

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Sort all workbook tabs after the Summary Tab

    Hello,

    I have a workbook that has many tabs in it. I want to create a macro that sorts every sheet after the sheet labeled Summary. I have sorting macro code that sorts the sheets but it is sorting every one of them even though I designated a starting sheet and ending sheet. It also sorted it descending and I wanted them ascending. Any help would be appreciated.

    Please Login or Register  to view this content.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Sort all workbook tabs after the Summary Tab

    You designated a starting and ending sheet, but the starting sheet is 1 and the ending sheet is ActiveWorkbook.Sheets.Count. That will include all the sheets in the workbook.

    In this line of code

    Please Login or Register  to view this content.
    The operation <> will always move the sheet. This does not work for sorting. Use > for an ascending sort.

    You are not using WksName for anything, so it can be deleted.

    To sort only the sheets after Summary:
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Sort all workbook tabs after the Summary Tab

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  4. #4
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Re: Sort all workbook tabs after the Summary Tab

    you my friend are a rock star. thank you 6String.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Sort all workbook tabs after the Summary Tab

    Glad I could help and thanks for the rep!

+ 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. collating multiple tabs within same workbook to create a master/summary tab
    By xotrujillo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-02-2016, 05:15 PM
  2. [SOLVED] vba to sort multiple sheet tabs in a workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-06-2016, 01:48 AM
  3. [SOLVED] Extract Data from multiple tabs in one workbook to a summary tab
    By iceplant in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2014, 12:36 PM
  4. Extract Data from multiple tabs in one workbook to a summary tab
    By iceplant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2014, 02:30 AM
  5. [SOLVED] Sort workbook Tabs only
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2014, 07:39 AM
  6. [SOLVED] Is it possible to sort the tabs in a workbook?
    By Jules in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 02:55 PM
  7. Can you sort sheet tabs in a workbook
    By Techtrainer in forum Excel General
    Replies: 5
    Last Post: 05-18-2006, 06:15 AM

Tags for this Thread

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