Automated worksheet: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 10: | Zeile 10: | ||
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=Die_Kontenmappe]] | |style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=Die_Kontenmappe]] | ||
|style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">Automated worksheet</div> | |style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">Automated worksheet</div> | ||
firesys offers | firesys offers a possibility to efficiently insert numerical values from the MeetingPoint into your Excel document with the automated worksheets. The information about accounts or account calculations are sufficient to insert directly key date-related values into the number columns.<br/> | ||
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=Die_Kontenmappe]] | |style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=Die_Kontenmappe]] | ||
|} | |} | ||
Version vom 2. Oktober 2020, 14:18 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. Based on the assignment of key dates for each column, the corresponding account values are inserted. 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