Vorlage:Video-Arbeitsblatt automatisieren-English
How to insert accounts and account calculations into an automated worksheet:
-
Open the worksheet where you want to insert accounts and/or account calculations.
-
In the master value column, select the row where the keydate should be inserted.
-
Click on the "Insert" button in the "*Content" menu in the "Master values" group.
-
A selection dialog opens in which you can now select "Automate worksheet".
-
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.
-
To insert an account calculation, select "Account calculation" in the drop-down area under "Data type".
-
Now you can see the selection of account calculations under "Values". Select the account calculation to be inserted.
-
Then click on the left button under "Actions" to insert the values in the table.
-
Next, click on the row of the master value column where an account is to be inserted.
-
Select "Accounts" in the task pane, under Data type.
-
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.
-
Under "Actions", click on the left button to insert the value of the account in the selected row.