Name generation

I have a team of 7 people, we have to assign work to another team, so one person doesn't get bombarded with work we assign to each person in turn i.e Zoe, Bill, Jim, Zoe, Bill, Jim etc etc.

Currently we use a paper tick sheet that gets passed around to make sure we assign in the right order.

Is there any way using excel I could have it so one of my team can open a spreadsheet click a button and it would show the next person to assign to.

I managed to get a basic version working for one person to access but not for up to 7 to have open at once and still generate the names in the right order.

At worst case I want all 7 people to be able to have this open at the same time and when any one of them clicks the button it generates the next name to assign to.

Many thanks for any help.

bump to the top