"Paul" wrote
I have a roster with 30 names on a fixed schedule for 15 weeks
i want to move the names through the schedule.

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
---