Automated worksheet: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 24: | Zeile 24: | ||
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | | style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | ||
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei: | <div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:Arbeitsblatt automatisieren menu.png|link=Automate_worksheet]] [[Automate_worksheet|Automate worksheet]]</div> | ||
<!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Automate_worksheet]]--> | <!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Automate_worksheet]]--> | ||
Insert accounts or account calculations from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column. <small>'''[[Automate_worksheet|mehr]]'''</small> | Insert accounts or account calculations from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column. <small>'''[[Automate_worksheet|mehr]]'''</small> |
Version vom 6. Oktober 2020, 13:16 Uhr
<imagemap>Datei:EN_Excel Menüband Inhalt Zentralwerte Bearbeiten-Einfügen-Lösen.jpg|center|1200px
desc none </imagemap>
| |||||
Create an automated worksheet that allows you to efficiently insert master values from the MeetingPoint. mehr
|
Insert accounts or account calculations from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column. mehr |
Text and number columns and other master value columns can be added to the automated worksheet. The definition of the columns can also be adjusted. mehr
| |||
Use this function to detach the automated worksheet from the MeetingPoint. mehr |
See also
Maintain Excel contents
Data import
The functions of the master value manager
Insert values in Excel
The validation basic functions
An overview of the rolling forward function