Help Centre › Building Processes
This article describes the RPA Excel functionality to move a sheet to a specific position in a workbook.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Move sheet function repositions a sheet within the workbook. You can move it to the first or last position, or place it before or after a named reference sheet.
Setting it up
To use the EXCEL Move sheet function, follow these instructions:
{{popups:rpas/add:action=excel-move-sheet}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Move sheet function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Move sheet option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | – | Name of the sheet to move |
| Position | Yes | Select | Last | Where to place the sheet: First, Last, Before, or After |
| Reference sheet | No | Text | – | Reference sheet name (required when position is Before or After) |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
| Reference sheet not found | The reference sheet does not exist (when using Before or After) |
Tips
- Use First or Last for simple repositioning without needing a reference sheet
- Use Before or After with a reference sheet name for precise placement
- Combine with Sort sheets for bulk reordering