Announcement

Collapse
No announcement yet.

Rename multiple workseets based on keyword

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Rename multiple workseets based on keyword



    Hello!
    I wodner if I can search and replace certain keyword in all worksheet tabs?

    Lets say I have these tabs:

    MODEL1
    MODEL2
    MODEL3

    Can I replace MODEL with SYSTEM ?

    Thanks!!!
    Dorian

  • #2
    try this. Sample file attached. Run macro "Rename_Sheets"

    sample.xlsm

    Comment


    • #3
      Fantastic - it works seamlessly - thanks a lot!

      Comment


      • #4
        can you please help me update this wonderful macro to cycle thgrough the names in column A on tab names and save the workbook after each cycle run with the name used to renbame the sheets?

        names on tab now:
        set1
        set2
        set3
        set4
        set5
        set6
        set7
        set8
        set9
        set10
        set11
        set12
        set13
        set14
        set15
        set16
        set17
        set18
        set19
        set20
        so it woudl rename all sheest with set1 and save the workbook as set1.xlsx and then go to set2

        can it be done?

        here is the update file:
        sample.xlsm

        Comment


        • #5


          I don't understand what you mean because you can't have the same name for a tab so you can't have two sheets named as "set1" in the same file

          Comment

          Working...
          X