Perhaps you might want to try this sample from my archives*:
http://savefile.com/files/5083813
Random_Scheduler_Melissa_wksht.xls
(it'll provide you some ideas to work with)

*archives link in sign-off below
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Belter" wrote:

Hi

Can someone help.

I've searched the forum and google but can't seem to find what i'm
looking for.

I need to do a work rota where it randomises the names in the columns
and rows and in equal number.

Please see attached to understand what i mean.

I have 7 employees in total

Thanks in advance


+-------------------------------------------------------------------+
|Filename: Rota.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=5138 |
+-------------------------------------------------------------------+

--
Belter
------------------------------------------------------------------------
Belter's Profile: http://www.excelforum.com/member.php...o&userid=37039
View this thread: http://www.excelforum.com/showthread...hreadid=567681