Copy a Worksheet

Creates a copy of an existing worksheet in the same Excel file.

Overview

This procedure creates a copy of an existing worksheet within the same Excel file (workbook). The copy includes all cell values, styles, hyperlinks, and comments from the original worksheet.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

copy a worksheet in the excel where

What does it do?

References an Excel file to copy a worksheet in.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — A reference to the excel must be defined in the automation.

the original worksheet name is "original-worksheet-name"

What does it do?

Specifies the name of the worksheet to copy.

Where does it go?

Indented under copy a worksheet in the excel where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace original-worksheet-name with the name of the worksheet to copy.

Example

the original worksheet name is "Data"

the new worksheet name is "new-worksheet-name"

What does it do?

Specifies the name for the copied worksheet.

Where does it go?

Indented under copy a worksheet in the excel where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace new-worksheet-name with the desired name for the copied worksheet.

Example

the new worksheet name is "Data_Backup"

Examples

1. Copy a Worksheet in the Excel

This example copies an existing worksheet with a new name.

copy a worksheet in the excel where
    the original worksheet name is "Data"
    the new worksheet name is "Data_Backup"