Philips CMS (Country Management Systems) were supplied with several huge spreadsheets from three separate sources which needed to be collated, modified and reports produced - including a driver statement for each company vehicle driver.
Philips CMS provides manages services for the rest of the Philips divisions, such as Healthcare and Lighting. As such they provide support for the company’s Fleet Department.
Macros were created to collate the three spreadsheets into one workbook, modify the formatting so they were identical. Once this was achieved a Pivot Tables was created to allow analysis of the data. Further Pivot Tables were automatically created, one for each of the 2,500+ company vehicle drivers, which resulted in an Excel workbook with over 2,500 worksheets in it.