Workflow Automation For Personnel Planning

A German car manufacturer, asked us to automate workflows for the planning of personnel costs within their Group. Each year the human resources managers send out templates to all the subsidiaries worldwide to collect data for the planning of salaries and bonusses. The subsidiaries fill out the templates and return them to the central department as email attachments. The email attachments then need to be consolidated into the master template. We could help the client to automate this process using Excel.


  • Tool programmed with Excel VBA
  • Master template is editable by users
  • Password protected cells inhibit accidentally overwriting formulas
  • Automated consolidation of individual template into master template
  • Archiving and backup of received, filled out templates
  • Version control
  • Password protected
  • Menu driven
  • Multi user

If interested in our services, please contact us for a free quote.

Excel Software Solutions