Hi,

This is really bugging me.

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...............13t
h..............14th.........'text entries to show date
3...........Name...............Friday............Saturday.......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