Hello,
I want to create an on-call contact list in Excel 2010 that rotates the order from week to week.
At the moment, there are 5 people in rotation, but to simplify it, here's what I'd be thinking of if there were only 3-people on call:
Week 1:
John 703.555.5555
Steve 703.666.6666
Mike 703.777.7777
Week 2:
Steve 703.666.6666
Mike 703.777.7777
John 703.555.5555
Week 3:
Mike 703.777.7777
John 703.555.5555
Steve 703.666.6666
Any suggestions on how I'd go about setting this up in Excel 2010?
Thanks in advance for any suggestions.
Svend
Bookmarks