+ Reply to Thread
Results 1 to 4 of 4

Alphabetizing sheets and isolating some to not be alphabetized

  1. #1
    Registered User
    Join Date
    01-28-2021
    Location
    Pennsylvania, USA
    MS-Off Ver
    2016
    Posts
    2

    Question Alphabetizing sheets and isolating some to not be alphabetized

    Hello there,

    I'm relatively familiar with Excel macros, but I can't find what I'm looking for anywhere. I have a fairly expansive spreadsheet that has 3 or 4 dozen sheets with varying names and it gets exceedingly difficult to find the right sheet when I either scroll through all of them or RClick the scrolling arrows and search for the right sheet. I found other's alphabetizing VBA macros, that works but I need to isolate 6 or 7 of the sheets to be at the front of the sheets that are alphabetized. Can someone help me understand how to get the result I'm looking for?

    I.E. *all values are arbitrary*
    X1-X50 = sheets, their order is random
    X4, X8, X24, X37, X15, X9, and X17 must remain in this respective order while remaining sheets are alphabetized either in ascending or descending order.

    The macro that I currently have is:
    ****************************
    Please Login or Register  to view this content.
    ****************************


    I tried editing it to fit my needs below:
    ****************************
    Please Login or Register  to view this content.
    ****************************


    Thank you
    Last edited by alansidman; 01-28-2021 at 12:45 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Alphabetizing sheets and isolating some to not be alphabetized

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,811

    Re: Alphabetizing sheets and isolating some to not be alphabetized

    Have you considered using the tab colour to exclude those sheets from the sort?

    For example you could run something to move all the sheets with yellow tabs to the left of the others, and then run the sort from the first uncoloured tab

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-28-2021
    Location
    Pennsylvania, USA
    MS-Off Ver
    2016
    Posts
    2

    Re: Alphabetizing sheets and isolating some to not be alphabetized

    Thank you for teaching me. I've read the rules now and plan on following them in the future.

    IT

+ 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. [SOLVED] Formula for unique list alphabetized
    By NS4Excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-03-2014, 06:30 PM
  2. Alphabetized Single Cell
    By lkurrt in forum Excel General
    Replies: 3
    Last Post: 09-19-2013, 01:30 PM
  3. Alphabetized Per Column Data
    By lkurrt in forum Excel General
    Replies: 2
    Last Post: 09-19-2013, 11:20 AM
  4. Bugs in my alphabetized search results
    By Gwen@YouWantWhat? in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-12-2012, 05:56 PM
  5. Edit/Update list from userform (auto alphabetized)
    By Jogier505 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-07-2009, 06:28 PM
  6. [SOLVED] Alphabetized data template
    By Dowjd in forum Excel General
    Replies: 3
    Last Post: 02-21-2008, 09:17 PM
  7. [SOLVED] Searching an Alphabetized list for data, then RESORT
    By FLKULCHAR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-18-2005, 12:05 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