Insert automated worksheet: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (4 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt) | |||
| Zeile 2: | Zeile 2: | ||
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.jpg|center|1200px]] | |||
== 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| | [[Datei:EN_Excel Inhalt Automatisertes Arbeitsblatt einfügen.jpg|mini|upright=2.0|250px|Dialog „Automate worksheet”]] | ||
=== [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|link=|24px]] Worksheet name === | === [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|link=|24px]] Worksheet name === | ||
| Zeile 20: | Zeile 19: | ||
=== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] Key dates === | === [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] Key dates === | ||
==== Add key date ==== | ====[[Datei:Image-Common-Plus.48.png|link=|16px]] Add key date ==== | ||
Adds another column of numbers to the automated worksheet. | Adds another column of numbers to the automated worksheet. | ||
==== Remove key date ==== | ==== [[Datei:Image-Common-Remove-X.png|16px]]Remove key date ==== | ||
Removes the selected column of numbers from the automated worksheet. | Removes the selected column of numbers from the automated worksheet. | ||
| Zeile 31: | Zeile 30: | ||
In this area, existing number columns (default: 2) are displayed. All existing key dates from the previously selected account group are displayed in the drop-down menu. | In this area, existing number columns (default: 2) are displayed. All existing key dates from the previously selected account group are displayed in the drop-down menu. | ||
==Video: Insert automated worksheet== | |||
{{Vorlage:Video-Automatisiertes Arbeitsblatt einfügen-English}} | |||
Aktuelle Version vom 19. November 2021, 13:27 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.
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:
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.
Account group
Select an account group from the MeetingPoint from which to provide key dates and master values.
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. All existing key dates from the previously selected account group are displayed in the drop-down menu.
Video: Insert automated worksheet
How to create an automated worksheet:
-
Open the workbook in which you want to create the Automated Worksheet.
-
Click on the "Insert" button in the "*Contents" menu bar in the "Master values" group.
→ A selection dialog opens -
select "Automated Worksheet".
-
Give your Automated Worksheet a name.
-
In the number columns, select which key dates your Automated Worksheet should have.
-
Confirm your entries by clicking on "OK".
→ The Automated Worksheet will be inserted with the selected values and you can continue to edit it.
See also
Automated worksheet
Automate worksheet
Edit automated worksheet
Detach automated worksheet