Vorlage:Video-Arbeitsblatt automatisieren-English

A detailed explanation of the individual steps

How to insert accounts and account calculations into an automated worksheet:

1. Open the worksheet where you want to insert accounts and/or account calculations.

2. In the master value column, select the row where the keydate should be inserted.

3. Click on the "Insert" button in the "*Content" menu in the "Master values" group.

4. A selection dialog opens in which you can now select "Automate worksheet".

5. On the right hand side the task pane "Automate Worksheet" appears, in which you press the right button under "Actions" to have the keydate inserted automatically.

6. To insert an account calculation, select "Account calculation" in the drop-down area under "Data type".

7. Now you can see the selection of account calculations under "Values". Select the account calculation to be inserted.

8. Then click on the left button under "Actions" to insert the values in the table.

9. Next, click on the row of the master value column where an account is to be inserted.

10. Select "Accounts" in the task pane, under Data type.

11. Under "Values", you can now select the account to be inserted. To find a specific account in a large number of accounts, you can also search directly for a specific account in the search field.

12. Under "Actions", click on the left button to insert the value of the account in the selected row.