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 Selector
onto the Targets
list in the target workbook to display the available target options. Continue
to drag the 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
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 Timing and Error settings, read the Action Builder article.
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 Switch
is 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, see Action Builder.
Click the OK
button to save the Action.