Better to use the OS scheduler, this is not really suited to Excel.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"b" wrote in message
...
hi,

i'm trying to use excel to arrange a yearlong work
schedule for 30 employees at work. i have been trying to
find a macro or macros that have already been made for
this but have been unsuccessful. any help would be
appreciated.

thanks
b