Forum Discussion
Creating a Master Sheet for Shift Rotas
Hello everyone, I am no expert when it comes to excel, I have created a spreadsheet with worksheets for each location I have staff working in. In each sheet's column A has all the staff names and...
Joe_Gates_BHL Why not put all information in one table and add a column for the location? That way, you can analyse data however you want it.
Hi Riny_van_Eekelen thanks for replying 🙂
How would that work if I have dates across the top (I need to be able to see which staff are working on specific dates) and staff names down the side. Not sure how I would split this per location in one table?
Thanks,
Perhaps a setup like this:
