+ Reply to Thread
Results 1 to 3 of 3

How to organize worksheets in a file based on contents in array

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,662

    How to organize worksheets in a file based on contents in array

    Hi,

    I found code that sorts sheets in alphabetical order but this is not what i am looking for.
    I am looking for code which sorts sheets to the order of the sheets in an array.

    For example: lets say you have 5 sheets in the file and they are named sheet1, sheet2, sheet3, sheet4 and sheet5

    Lets say i have an array that contains all 5 of the sheets names.
    contents in the array are sheet5, sheet2, sheet3, sheet1, sheet4.............and this is the same order i want my sheets in the file in.........any idea how ot do this?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: How to organize worksheets in a file based on contents in array

    Try this:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: How to organize worksheets in a file based on contents in array

    Thanks for the rep.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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] split and organize values from array to new array
    By guillaume0314 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-22-2024, 02:33 PM
  2. [SOLVED] Compare an array in one file against contents of another file
    By TexARC in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-20-2020, 09:46 PM
  3. Pull row and column titles based on array contents
    By qwertys in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2018, 07:37 PM
  4. Replies: 5
    Last Post: 02-16-2015, 03:31 AM
  5. Replies: 1
    Last Post: 06-04-2013, 03:01 PM
  6. Replies: 3
    Last Post: 05-03-2012, 10:56 AM
  7. How do I organize worksheets under subheadings?
    By Alison in forum Excel General
    Replies: 0
    Last Post: 08-08-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1