Hi Paul,
I would try an Excel web search  on your Google toolbar or at
   http://www.google.com/advanced_search?hl=en      for
       excel  rotation OR rota  schedule OR timesheets

and a Google Groups search on a dropdown on your Google toolbar or at
   http://groups.google.com/grphp?hl=en&tab=wg&q=
       rotation OR rota schedule OR timesheets  group:*excel*

to get you started then ask specific questions if that does not provide enough
information.
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

Just an option to tinker with ..

Sample construct at:
http://www.savefile.com/files/7312953
30 names 15 weeks rotation schedule_paul_newusers.xls

In Sheet1, list the 30 names in A1:A30
Put in A31: =A1
Copy A31 down to A60 to repeat the name list

Then in say, Sheet2, to create the schedule ..

Put in A1: Week1, copy A1 across to O1
(this simply creates arbitrary labels for the 15 weeks in A1:O1)

Put in A2:
=OFFSET(INDIRECT("'Sheet1'!A"&ROW(A1)),COLUMN(A1)-1,)
Copy A2 across to O2, fill down to O31 to populate the schedule

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---