WSheet Add []

You can add a new worksheet next to an already used worksheet on the fly with the following parameters:

• (Optional) Djeeni name: this name identifies the worksheet during the process. If it is not given then the worksheet will be created but will not be usable further in the process.
• Excel name of the new worksheet: According to the MS Excel naming standard
• Next to worksheet: The Djeeni name of an already used worksheet.

Example: For a new month a worksheet is added to a budget workbook next to the last month

WSheet Add

  Djeeni Name:=ActualMonth
  Name:=April2018
  Next to worksheet:=LastMonth

NB: In case you ask if ‘April2018’ should be changed manually every month: the above code can be made much more sophisticated /automated using Djeeni formulas (see below).