Vorlage:Video-Arbeitsblatt automatisieren mit Optionen-English

A detailed explanation of the individual steps

How to use the options in the automated worksheet:

1. Open the workbook with the automated worksheet in which you want to insert values.

2. Click the "Insert" button in the "*Contents" menu in the "Master values" group.
   → A selection dialog opens

3. select "Automate worksheet".

4. While the master value cell to be filled is selected, search in the task pane under "Values" for the account to be inserted. The middle button under "Actions" transfers the corresponding values including the name to the corresponding row.

5. Now select the cell in which an inverted value should be inserted.

6. After selecting the correct account, click on #invert under "Options" and select the left button under "Actions" to transfer the values without text. Here the signs were reversed.

7. Next, select the cell with the average value in which an absolute value is to be inserted.

8. After selecting the desired account, click on #absolute under "Options" and select the left button under "Actions" to transfer the values without text. Here the signs were ignored.