+ Reply to Thread
Results 1 to 6 of 6

Rearrange the Sheet Names based on List string present

  1. #1
    Registered User
    Join Date
    04-06-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    20

    Rearrange the Sheet Names based on List string present

    Hi ,

    I have a workbook containing the 100 sheets each are not in order of precedence, I have precedence order defined in the first sheet which is named as "Executions" and it has list from A2 to Last row of it. so, for example, now A2 has string value as "Apple is Red" and that string exists somewhere last sheet in particular cells in Each sheet then re-order based on the order of "Executions" Sheets.

    Please view the attachment which has more detail.

    Thank You
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Rearrange the Sheet Names based on List string present

    Possibly...
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,585

    Re: Rearrange the Sheet Names based on List string present

    Macro code:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  4. #4
    Registered User
    Join Date
    04-06-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    20

    Re: Rearrange the Sheet Names based on List string present

    Thanks @dangelor

  5. #5
    Registered User
    Join Date
    04-06-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    20

    Re: Rearrange the Sheet Names based on List string present

    Thanks, @kvsrinivasamurthy

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,585

    Re: Rearrange the Sheet Names based on List string present

    Thanks for feedback and 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. [SOLVED] Replace present formula names with reference data sheet names list
    By Khaldon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2021, 09:41 AM
  2. [SOLVED] Duplicate Template sheet based on names in List sheet
    By Ravana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2018, 01:35 PM
  3. [SOLVED] Extract names in a list, and present in order, based on qty criteria.
    By TrondG in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-23-2016, 08:04 AM
  4. Extracting names not present in a sheet
    By crouzilles in forum Excel General
    Replies: 2
    Last Post: 06-24-2015, 11:18 AM
  5. Replies: 3
    Last Post: 10-01-2014, 01:49 PM
  6. [SOLVED] List out the file names present in the folder using excel macro
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 66
    Last Post: 04-30-2014, 01:18 AM
  7. [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

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