HOW TO MAKE A ROTA IN EXCEL
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 |
All times are GMT +1. The time now is 06:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com