Automated worksheet: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 26: | Zeile 26: | ||
<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> | <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 | Insert accounts, account calculations or account aggregates from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column. <small>'''[[Automate_worksheet|mehr]]'''</small> | ||
----- | ----- | ||
</div> | </div> |
Version vom 29. März 2021, 11:57 Uhr
<imagemap>Datei:EN_Menüband_Excel_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, account calculations or account aggregates 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