# Copy a Worksheet in the Excel

### 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.

<details>

<summary><code>copy a worksheet in the excel where</code></summary>

#### 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.

</details>

<details>

<summary><code>the original worksheet name is "original-worksheet-name"</code></summary>

#### 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"
```

</details>

<details>

<summary><code>the new worksheet name is "new-worksheet-name"</code></summary>

#### 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"
```

</details>

### 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"
```