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 with the automated worksheets a possibility to efficiently insert numerical values from the MeetingPoint into your Excel document. 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]] | ||
|} | |} | ||
| Zeile 19: | Zeile 19: | ||
<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Insert_automated_worksheet]]--> | <!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Insert_automated_worksheet]]--> | ||
Create an automated worksheet that allows you to efficiently insert master values from the MeetingPoint. <small>'''[[Insert_automated_worksheet|mehr]]'''</small> | |||
---- | ---- | ||
| 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:rxbtnCellInsertTargetCells_32.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:rxbtnCellInsertTargetCells_32.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. Based on the assignment of key dates for each column, the corresponding account values are inserted. <small>'''[[Automate_worksheet|mehr]]'''</small> | |||
----- | ----- | ||
</div> | </div> | ||
| Zeile 33: | Zeile 33: | ||
<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:rxbtnCellCodedSheetEdit_32.png|link=Edit_automated_worksheet]] [[Edit_automated_worksheet|Edit automated 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:rxbtnCellCodedSheetEdit_32.png|link=Edit_automated_worksheet]] [[Edit_automated_worksheet|Edit automated worksheet]]</div> | ||
<!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Edit_automated_worksheet]]--> | <!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Edit_automated_worksheet]]--> | ||
Text | 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. <small>'''[[Edit_automated_worksheet|mehr]]'''</small> | ||
----- | ----- | ||
</div> | </div> | ||
| Zeile 43: | Zeile 43: | ||
<!--[[Datei:Vorrollen.jpg|left|175px|Testbild|link=Detach_automated_worksheet]]--> | <!--[[Datei:Vorrollen.jpg|left|175px|Testbild|link=Detach_automated_worksheet]]--> | ||
Use this function to detach the automated worksheet from the MeetingPoint. <small>'''[[Detach_automated_worksheet|mehr]]'''</small> | |||
----- | ----- | ||
| | | | ||
Version vom 2. Oktober 2020, 09:53 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