How to duplicate teh sheet tab with new name as per source file tab names.

Chaturvedi, Santosh 590 Reputation points
2026-09-30T14:33:18.6366667+00:00

I have on e souce sheet have following sheet tab name :

  1. TK_GV_vorlaufend
  2. TK_GV_vorlaufend

I have new work book & with tab called CSL31 which is formulated.

I want to duplicate the CSL31 tab in new qork book two times renaming the two tabs as source file tab name as: 1. TK_GV_vorlaufend, 2. TK_GV_vorlaufend

How to do this - please advice and please do use power qury

Microsoft 365 and Office | Excel | Other | Windows
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Thomas4-N 22,380 Reputation points Microsoft External Staff Moderator
    2026-10-03T14:03:20.71+00:00

    Hello Chaturvedi, Santosh,

    Thanks for clarifying. Since there are many tabs, a VBA macro makes more sense than copying CSL31 manually.

    Before I give you the macro, could you confirm one detail? Your example lists TK_GV_vorlaufend twice. Are those actual worksheet tab names in the source workbook, or names in a separate list? If the repeated name is intentional, what should the second copied sheet be called? The two copies cannot have the same tab name in one workbook.

    Was this answer helpful?

  2. Chaturvedi, Santosh 590 Reputation points
    2026-09-30T14:34:37.62+00:00

    There are many sheets tab are there.. If possibl eplease suggest macro

    Was this answer helpful?

    0 comments

  3. AI answer

    2026-09-30T14:33:34.2633333+00:00

    If the goal is to create copies of the CSL31 sheet and rename them to match sheet names from another workbook, these are the supported Excel options from the available guidance:

    1. Right-click the CSL31 worksheet tab.
    2. Select Move or Copy.
    3. In Move selected sheets to Book, select (new book) if the sheet must be saved separately, or copy within the workbook if staying in the same workbook.
    4. Select Create a copy if the original CSL31 sheet must remain unchanged.
    5. After the copy is created, rename the copied sheet:
      • Double-click the sheet tab and type the new name, or
      • Right-click the sheet tab and select Rename.

    Worksheet naming rules:

    • Name cannot be blank.
    • Name cannot be more than 31 characters.
    • Name cannot contain / \ ? * : [ ].
    • Name cannot begin or end with an apostrophe (').
    • Name cannot be History.

    Important limitation:

    • Excel does not allow duplicate worksheet names in the same workbook. The example provided lists TK_GV_vorlaufend twice. If both copied tabs are in the same workbook, the second one cannot use the exact same name. One of them must be different, such as:
      • TK_GV_vorlaufend
      • TK_GV_vorlaufend_2

    If copying a worksheet into another workbook triggers a Name Conflict dialog box, that means both workbooks contain similar named ranges. Excel will prompt to use the existing name or rename the one being copied.

    If using Excel for the web, duplicating within the current workbook is available by right-clicking the sheet tab and selecting Duplicate. If duplication fails because the sheet contains a chart, picture, or shape, copy all data with CTRL+C and paste into a new blank worksheet with CTRL+V. Note that conditional formatting is lost in that manual method.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.