Hi
I am trying to put together a rota which involves 11 people on a 11 week rotating rota whch need to be input on a 5 week rota.
Is there a way so I could put a week number into a cell and it would populate a number of cells with the names of the people on the shift that day ?
Thanks
Pivot Table can do that.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks