create work schedule in Excell (6employees rotating shifts)
Its not a simple task and excel is hardly better than a paper and a pen
when it comes to this unless you use VBA http://blog.jausovec.net/ if you go there, then click at the files link there is a template for creating work schedules, should probably work for at least excel 2000-2003 -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "suzyg23" wrote in message ... Hi there, I would like to create a calender in excell. I want it to look like an ordinary calendar (1 month per page) we have 6 employees and they all work a rotation of 6 on 3 off. I want to be able to enter formulas so that the calendar becomes perpetual and I don't have to do them manually on a monthly basis. I am hoping not to have to buy additional software. Thanks for all your' help, Sue |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com