I just need a push in the right direction, trying to solve a rota problem that I have for a friend, my friend works for a charity that has approx 40 volunteers, they use 2 volunteers per night on a sun to thursday, but some (approx 10 people) of the volunteers cant do nights, so im trying to set up a rota spreadsheet that will skip certain numbers that are allocated to each person, so on sunday we have persons 1 & 2, on monday persons 3 & 4, on tues we would skip person 5 so 6 & 7 would be on then, weds would have person 8, skip 9, and have person 10, and when it gets to person 20, instead of going to 41, it would revert back to person 1, can this be easily done, i think i just need a push in the right direction, then i can modify and use a new rota to make things faster

regards

Paul Armstrong