Weekly roster

andrewrgd

Board Regular
Joined
Dec 30, 2004
Messages
78
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,147,621
Messages
5,742,193
Members
423,710
Latest member
Duarte85

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top