Vacation Log

A small utility built at a manager’s request. The tool gives a visual representation of employee vacation schedules and highlights overlapping time periods when multiple team members are away simultaneously.

My manager had previously built the report by hand, which was time-consuming. I offered to automate it. The spreadsheet only requires that the list of vacations on the left be maintained — an update button then regenerates the full report in columns F and beyond.

A decent demonstration of my VBA macro development skills.