Microsoft Office Productivity Specialists
Support, Training & Automation that . . .
Inspires * Saves time, money & effort Entertains
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.