A while back the responsibility for maintaining a staff rota fell to one of the members of my team. They asked it I could provide something in Excel that would make it easier to compile, publish the required html and keep track of the rota. We both had a search around but were surprised to find very little on the web, so I came up with a workbook from scratch.

I ended up using a Form interface, some VBA, activeX controls to produce graphs and 5 worksheets to hold the data.

Download: web_rota.xls

If you'd like the password to be able to access the VBA and hidden worksheets just drop me an e-mail.