Use the Copy worksheet action to copy values of a worksheet from one worksheet to another. This action overwrites any existing values. To move values from one worksheet to another without overwriting existing values, use the Append worksheet action.

Prerequisites

Open the workbook(s) containing the source and target worksheets. See Using the Open action.
Note: This action identifies the destination and source workbooks by the session names used to open them. If opening two workbooks, enter a session name for the source workbook that is different than the one used to open the destination workbook.
To copy the values of a worksheet into another, do the following:

Procedure

  1. Double-click or drag the Copy worksheet action.
  2. Enter the name of the session that you used to open the destination workbook in the Open action.
  3. If the workbook contains more than one worksheet, mark the Specific Sheet option, then enter the index number or name of the source worksheet.
    • The index number represents the position of the worksheet in the workbook. For example, to perform an operation on the worksheet at the third position in the workbook, enter 3 in the field.
    • The sheet name field is case insensitive.
  4. Enter the name of the session that you used to open the source workbook in the Open action.
  5. If the workbook contains more than one worksheet, mark the Specific Sheet option, then enter the index number or name of the destination worksheet.
  6. Click Save.