Formula help - creating a calendar from validation list & populating with dynamic user list

[wjvghost]

Hello,

I am trying to create a weekly calendar from a data validation list which will populate cells with users based on the selection.

I have a list of 15 users with different names, and I want it to be able to populate in order and be able to "wrap around" to the next week selection.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Monday ##
[/TD]
[TD]Tuesday ##
[/TD]
[TD]Wednesday ##
[/TD]
[TD]Thursday ##
[/TD]
[TD]Friday ##
[/TD]
[/TR]
[TR]
[TD]Time Slot
[/TD]
[TD]worklane
[/TD]
[TD]worklane
[/TD]
[TD]worklane
[/TD]
[TD]worklane
[/TD]
[TD]worklane
[/TD]
[/TR]
[TR]
[TD]9:30
[/TD]
[TD]Tom
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10:30
[/TD]
[TD]Larry
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11:30
[/TD]
[TD]Joe
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

I have more time slots than this but that should be non issue to add once I get this figured out. I wanted to know if there was a way via formula to determine the next user in line from the list based on the previous entry.