Vorlage:Video-Tabellen vorrollen-English

A detailed explanation of the individual steps

Setting up the roll forward function

1. Open the worksheet containing the table that should be set up for using the “roll forward” function.

2. In the *Content“ menu ribbon, in the “Roll forward” group, click on the upper part of the “Work area” split button to open the “Roll forward” work area.

3. Use the mouse to navigate to the table column in which the values from a different column should be rolled forward. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area. The selected column is now displayed in the list area.

4. Navigate with the mouse to the table column from which values should be rolled forward in a different column. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area. The list area now also displays the selected column - and a blue arrow points in the direction of the values to be rolled forward.

5. Then click on the “Save” icon in the “Changes” group in the “Roll forward” work area, and the work area closes automatically.

Executing the “Roll forward” function

1. In the “*Content” menu ribbon, in the “Roll forward” group, click on the “Execute” button.

2. A dialogue opens displaying information about the last successful “roll forward” process and optionally enables you to specify a free text that is used in the “roll forward” history. Before executing the “roll forward” process, if you want to obtain information about which worksheets are being rolled forward, click on the “Status update“ button.

3. Clicking on “Start” starts the “roll forward” process.
   Note: Any changes that were not saved must be saved beforehand – furthermore, firesys creates a backup copy of your workbook which you must also consent to.

4. Your workbook is rolled forward.