Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Tough problem with rotas
i have a weekly roster of 35 staff members in the following format
................A.....................B........... ........C.................D...................E 1............<<merged cells - Heading......................................... ........ 2....................................11th......... ....12th...............13th..............14th..... ....'text entries to show date 3...........Name...............Friday............S aturday.......Sunday..........Monday....'text entries of the day 4...........Staff 1............10:30 - 5:00...........................12 - 11..........5:15 - 12...'text entries showing when they're working 5...........Staff 2...................................5:15 - 12.............................12 - 11..... what i'ld like to do is automatically generate two new sheets for each day of the week listing the staff member and times that they're working - the first sheet will be for morning people (shifts begining at 10:30), the second sheet for afternoon people, (shifts beginning at either 5.15 or 12) any ideas? thanks in advance scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
autofilter problem | Excel Worksheet Functions | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |