Move Sheet
This article provides information on the following topics:
Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.
What is the Move Sheet Action?
The Move Sheet Action moves a specific sheet to a new position.
Creating a Move Sheet Action
Drag and drop the Target Selector onto the Targets list in the target workbook to display the available target options. Continue to drag the Target Selector to the Sheets item, releasing your mouse to display the Target Preview. As an alternative, you may also target the Sheets tab along the bottom of the workbook. If this is the first time the workbook was targeted, Nintex RPA LE will attempt to create a workbook connection automatically. (For more information about Microsoft Excel workbook connections, read the Excel Connections article.)
A preview of the target is displayed. Select the Move Sheet Action from the Actions list.
Select the Rules to change the Connection for this Action. Both the Timing and Error settings for this action may be configured to fine tune the how the Action will run.
Note: For more information about the timing and error settings, go to Action Builder.
Select the sheet to move from the list. Then, select how to move the sheet . The following Move options are available:
- Left
- Right
- First
- Last
- Specific Position
When the Left or Right options are chosen, you will be asked to specify the number of moves to move the Sheet. When the Specific Position option is chosen, you will be asked to provide the position number for the Sheet.
Optionally add Notes to the Action to document any special instructions or functionality. When the Run Switchis set to Run, the action will be executed after clicking OK.
Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run. For more information, go to Action Builder.
Click the OK button to save the Action.