Creation of a tool with MS Excel/VBA that extracts data from a defined spreadsheet in one file for each group company and uses this data to create a text file for uploading to SAP.
Supplement
The tool uses data from a spreadsheet for the source files of all group companies to create a text file for uploading to SAP. To achieve this, the data is first collected in a spreadsheet within the tool and it is exported to a text file.
Subject description
For group controlling, certain data from multiple input files has to be made available for uploading to SAP. The application created here automates this process for the customer.