Multiple Worksheets

GLSU spreadsheets can have multiple worksheets. When posting, each of these worksheets will create a separate SAP document.

When posting, you may wish to post one, all, or a range of these worksheets in your spreadsheet. You could use this feature to have GLSU ignore a worksheet which contains all of your calculations feeding the posting worksheet(s) via formulas.

From the GLSU menu,

1. Select the Options menu item.

   

2. Adjust worksheet options as required. You can choose to export a single worksheet by choosing option Export Active Worksheet Only. Choose a range by selecting option Export Range of Worksheets and then typing in the range of worksheets in the two fields below (see screenshot above).
3. If you wish to export a selection of specific sheets, select Process Selected Sheets and then press the Select button.

   

Note: You can use multiple worksheets to book allocations across company codes. Use a different worksheet for each company.