+ Reply to Thread
Results 1 to 3 of 3

select multiple worksheets by partial name

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    Sidney, BC
    MS-Off Ver
    Excel 2010
    Posts
    43

    select multiple worksheets by partial name

    I have a workbook with worksheets named in the following way, where A, B, and C stand for different words :

    A, B, C, A (1), B (1), C (1), A (2), B (2), C (2),...A (52), B (52), C (52)

    Sometimes I need to select all the A sheets or all of the B or C sheets to make changes that will apply to all those sheets. So far I have done this by scrolling through the worksheet tabs and CTRL+mouse clicking each tab I want to group. This is tedious and time consuming. May I ask someone to create a macro that will allow me to choose A, B, or C and then will group all of the worksheets that have A, B, or C as the first part of the worksheets' name?

    I should mention that worksheet A is not the first worksheet in the workbook. I have three worksheets before A but they do not follow the naming pattern shown above.

    Arthur
    Last edited by amenu; 01-23-2019 at 05:40 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: select multiple worksheets by partial name

    Hiya, try to see if this works for you...

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-02-2012
    Location
    Sidney, BC
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: select multiple worksheets by partial name

    Thank you, Poizhan! Your macro worked like a charm. You have saved me hours of work over the coming year.

    Arthur

+ 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. Sumif Across multiple Worksheets using Partial Tab Name
    By TotallyLost in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-14-2017, 07:44 AM
  2. [SOLVED] Select Multiple Worksheets
    By plans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2014, 05:07 PM
  3. Multiselect Listbox to select multiple worksheets
    By Alagu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2012, 01:28 AM
  4. [SOLVED] Select Multiple Worksheets based on Cell Array
    By jwbehm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2012, 05:16 PM
  5. Select cells from multiple worksheets
    By kolovel in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 07:44 AM
  6. Moving select worksheets from multiple file to one workbook
    By jkolstoe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2011, 07:41 PM
  7. [SOLVED] How do I select multiple worksheets for print preview?
    By steve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2005, 02:06 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