The Copy worksheet instruction allows you to copy a worksheet from an existing workbook to a target workbook. The instruction will behave as if you had manually selected the worksheet in Excel and copied it.

Working with the instruction

Create a new instruction

Firstly, create an action step to manipulate data and select "Copy worksheet" in the "Excel" section or type the name in the search bar, as shown below.

Configure the instruction

Configure the instruction using the following steps:

1. Link a source workbook stored in a data step within a process;

2. Select a worksheet that you want to copy. If you want to copy all worksheets, skip this setting and proceed with step 5;

3. Link a workbook stored in a data step where the worksheet will be copied to;

4. Optionally choose the name of the new worksheet;

5. Configure additional settings:

a. Choose if you want to copy all sheets in the workbook;

b. Choose what should happen when a worksheet with the same name exists in the target workbook:

- "Fail with error" option instructs the step to fail if it finds at least one worksheet with the same name;

- "Replace worksheet contents" option instructs the step to replace the contents of the target worksheet with the contents of the source worksheet with the same name;

- "Increment worksheet name" option instructs the step to increment the worksheet's name in the target workbook and copy the contents from a source worksheet.