Im looking to design a simple rota in excel. It will contain 12 names in it
and will contain 5 poistions to be covered on a weekly basis.

Im looking to design a simple rota in excel. It will contain 12 names
in it and will contain 5 positions to be covered on a weekly basis.

One way is illustrated by the CSV file below.

(The first line is 85 characters long, and might get split by the newsgroup
software.)

===== cut here =====
,"=DATE(2005,10,1)",=B1+7,=C1+7,=D1+7,=E1+7,=F1+7, =G1+7,=H1+7,=I1+7,=J1+7,=
K1+7,=L1+7
Prep,Les,Jan,Jo,Moe,Lee,Al,Kim,Ed,Bee,Sy,Mia,Ted
Clean,=C2,=D2,=E2,=F2,=G2,=H2,=I2,=J2,=K2,=L2,=M2, =B2
Sweep,=C3,=D3,=E3,=F3,=G3,=H3,=I3,=J3,=K3,=L3,=M3, =B3
Laundry,=C4,=D4,=E4,=F4,=G4,=H4,=I4,=J4,=K4,=L4,=M 4,=B4
Garden,=C5,=D5,=E5,=F5,=G5,=H5,=I5,=J5,=K5,=L5,=M5 ,=B5