Vorlage:Video-Arbeitsblatt automatisieren-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 6: | Zeile 6: | ||
<div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | <div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | ||
<div class="mw-collapsible-content"> | <div class="mw-collapsible-content"> | ||
<p align="left"> | <p align="left">How to insert accounts and account calculations into an automated worksheet:<br><br> | ||
<p align="left"> | <p align="left"> | ||
<ul> | <ul> | ||
<li> <p align="left"> | <li> <p align="left">Open the worksheet where you want to insert accounts and/or account calculations.</li> | ||
<li> <p align="left"> | <li> <p align="left">In the master value column, select the row where the keydate should be inserted.</li> | ||
<li> <p align="left"> | <li> <p align="left">Click on the <b>"Insert"</b> button in the <b>"*Content"</b> menu in the <b>"Master values"</b> group.</li> | ||
<li> <p align="left"> | <li> <p align="left">A selection dialog opens in which you can now select <b>"Automate worksheet"</b>.</li> | ||
<li> <p align="left"> | <li> <p align="left">On the right hand side the task pane <b>"Automate Worksheet"</b> appears, in which you press the right button under <b>"Actions"</b> to have the keydate inserted automatically.</li> | ||
<p align="left"> | <p align="left">To insert an account calculation, select <b>"Account calculation"</b> in the drop-down area under <b>"Data type"</b>.</li> | ||
<li> <p align="left"> | <li> <p align="left">Now you can see the selection of account calculations under <b>"Values"</b>. Select the account calculation to be inserted.</li> | ||
<li> <p align="left"> | <li> <p align="left">Then click on the left button under <b>"Actions"</b> to insert the values in the table.</li> | ||
<li> <p align="left"> | <li> <p align="left">Next, click on the row of the master value column where an account is to be inserted.</li> | ||
<li> <p align="left"> | <li> <p align="left">Select <b>"Accounts"</b> in the task pane, under Data type.</li> | ||
<li> <p align="left"> | <li> <p align="left">Under <b>"Values"</b>, 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.</li> | ||
<li> <p align="left"> | <li> <p align="left">Under <b>"Actions"</b>, click on the left button to insert the value of the account in the selected row.</li> | ||
Version vom 5. Oktober 2020, 14:22 Uhr
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.
-
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.
To insert an account calculation, select "Account calculation" in the drop-down area under "Data type".