Vacation Log
This was a small utility I made at the request of my manager. He'd been using this report to get a visual of who's going to be on vacation and when. It also easily shows where the overlap is between multiple people taking vacation at the same time.
He had been painstakingly building the report by hand. I offered to automate the creation of the report. All that is required is the list of vacations to the left of the spreadsheet be maintained. The update button builds everything automatically to the right of the F column. I thought this might be a descent demonstration of my VBA macro development skills.
Download |
Preview image |