+ Reply to Thread
Results 1 to 5 of 5

Excel Macro: Rename Multiple Worksheets based on List

  1. #1
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Excel Macro: Rename Multiple Worksheets based on List

    Hi Excelforum Experts,

    I have an excel tool that will consolidate multiple worksheets into one workbook from a desired folder. However, I am having a hard time renaming each worksheet based on list. I have attached the sample workbooks for more details.

    Here are the steps that I want to add up on my existing macro codes:

    1.) After consolidating multiple worksheets into one, I would like to rename each worksheet based on the list which can be found in the attached workbook named "Conso Tool".
    2.) Each current worksheet name has its corresponding desired worksheet name which can be found in "Worksheet Name" tab.
    3.) Lastly, the consolidated workbook should be in .xlsx format.

    Any inputs and ideas will be highly appreciated. Thank you!

    Warmest regards,
    Arnel
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,302

    Re: Excel Macro: Rename Multiple Worksheets based on List

    You can't have 35 char tab names in my excel. So I cut it to 31 instead.

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Re: Excel Macro: Rename Multiple Worksheets based on List

    Hi scottiex,

    Thank you for your immediate feedback. However, I am having an error as shown on screenshot below:

    VBA Code Error_001.png

    Warmest regards,
    Arnel

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,302

    Re: Excel Macro: Rename Multiple Worksheets based on List

    ahh I opened your file but didn't read your post properly

    here is a rename based on that table
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Re: Excel Macro: Rename Multiple Worksheets based on List

    Hi scottiex,

    I made a tweak for some ranges and it works well.

    Thanks for your quick feedback and input. I appreciate it much!

    Warmest regards,
    Arnel

+ 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. My File Rename Macro Always Doesn't Rename the Last Three files in the list
    By Enright in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2016, 03:46 PM
  2. [SOLVED] Problem with macro to copy then rename worksheets based on a list
    By Ellen 2Excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2013, 01:06 PM
  3. macro to copy a range of worksheets based on cell entry and rename specific sheets
    By Lbischoff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2012, 12:13 PM
  4. Macro to rename sheet based on date in a cell with multiple occurrences.
    By timlocke in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2011, 03:08 PM
  5. Rename all worksheets created from macro according to list on Column A
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2011, 06:29 PM
  6. Rename files based on excel worksheet list
    By badgeradrian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2009, 05:52 PM
  7. Replies: 5
    Last Post: 03-24-2005, 03: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