’m trying to create a staff rota for a 3 month period for my team and there are a few rules.
I have been trying to do it manually but it is taking me ages to do so.. As an added bonus if it can take into account annual leave that would be even better.
Ideally, I am looking for a rota that can auto populate itself. If possible, I would like to include annual leave as one of the rules so that the spreadsheet does not give people shifts when they are off. This is not mandatory but it would be ideal.
One more big ask – if I have more staff joining, would it be possible to simply add their name to the list and the spreadsheet will autopopulate?
Please view the attached spreadsheet and word document for information
27 pekerja bebas membida secara purata $37 untuk pekerjaan ini
Hi there, I am pretty experienced in Excel, have taken a look at the attachments and will be able to do it. Relevant Skills and Experience Excel, Macros, Models, Formulas Proposed Milestones $20 USD - Final Sheet