I've been working on a staff roster spreadsheet. The sheet is completed on a weekly basis to show what staff are covering shifts - Monday to Friday along the top and office locations + other fields (i.e. annual leave) on the side. The spreadsheet is fairly sophisticated - I've used validation listboxes so the user can select a work employee from a list and using an ID code in the annual leave, sick fields.
I then want to capture some management info on a monthly basis i.e how many shifts a member of staff have covered, number of sick days etc. I would image using countif to do this. However, the problem I have is (1) what's the best way to collate the weekly sheets as different offices are filling out different rotas and secondly (2) how to show monthly stats as the sheets on done on a weekly basis and may cut across a calander month.
Any ideas would be appreciated.
Cheers
I then want to capture some management info on a monthly basis i.e how many shifts a member of staff have covered, number of sick days etc. I would image using countif to do this. However, the problem I have is (1) what's the best way to collate the weekly sheets as different offices are filling out different rotas and secondly (2) how to show monthly stats as the sheets on done on a weekly basis and may cut across a calander month.
Any ideas would be appreciated.
Cheers
