Insert automated worksheet: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 10: Zeile 10:
== Insert ==
== Insert ==
To insert an automated worksheet, click the “Insert” button in the “Master values” group on the “*Contents” menu bar and select “Automated worksheet” in the dialogue box. The following dialogue opens:
To insert an automated worksheet, click the “Insert” button in the “Master values” group on the “*Contents” menu bar and select “Automated worksheet” in the dialogue box. The following dialogue opens:
[[Datei:EN_Excel Inhalt Automatisertes Arbeitsblatt einfügen.jpg|mini|upright=2.0|Dialog „Automate worksheet”]]
[[Datei:EN_Excel Inhalt Automatisertes Arbeitsblatt einfügen.jpg|mini|upright=2.0|300px|Dialog „Automate worksheet”]]


=== [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|20px|link=]] Worksheet name ===
=== [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|link=|24px]] Worksheet name ===
Create a new automated worksheet; all you have to do is assign a name that has not yet been assigned in the workbook.
Create a new automated worksheet; all you have to do is assign a name that has not yet been assigned in the workbook.



Version vom 2. Oktober 2020, 10:59 Uhr

Creates an automated worksheet that allows you to automate the worksheet with master values from the MeetingPoint. The new worksheet is then inserted into the Excel file.


<imagemap>Datei:EN_Excel Menüband Inhalt Zentralwerte Einfügen.jpg|center|1200px

desc none </imagemap>


Insert

To insert an automated worksheet, click the “Insert” button in the “Master values” group on the “*Contents” menu bar and select “Automated worksheet” in the dialogue box. The following dialogue opens:

Dialog „Automate worksheet”

Firesys Icons BubbleTransparent 1 white background.png Worksheet name

Create a new automated worksheet; all you have to do is assign a name that has not yet been assigned in the workbook.

Firesys Icons BubbleTransparent 2 white background.png Account group

Select an account group from the MeetingPoint from which to provide key dates and master values.

Firesys Icons BubbleTransparent 3 white background.png Key dates

Add key date

Adds another column of numbers to the automated worksheet.

Remove key date

Removes the selected column of numbers from the automated worksheet.

Select key date

In this area, existing number columns (default: 2) are displayed. In the drop-down menu all existing key dates from the previously selected account group are displayed.


See also

Navigation hoch.svg Automated worksheet
Navigation rechts.svg Automate worksheet
Navigation rechts.svg Edit automated worksheet
Navigation rechts.svg Detach automated worksheet


Further contents

firesys website
Customer area
YouTube