Never had much to do with excel before, but am trying to work out a
problem with a roster system. On sheet 1, the roster looks something
like this

Person a 700
Person b 1430
Person c 730
person d 1230
Person e 700
Person f 1430
Person g ARL
Person h 930
Person i 930
Person j 700

column A being the persons name and column B is the time the shift
starts. On sheet 2, I then want to retrieve the info and group it in
time slots like so

Person a 700
Person c 730
Person e 700
Person j 700


Person h 930
Person i 930


Person b 1430
person d 1230
Person f 1430

so it can be printed off for a daily allocation sheet.

Any help would be greatly appreciated.

Thanx :)


--
Hartygan
------------------------------------------------------------------------
Hartygan's Profile: http://www.excelforum.com/member.php...o&userid=26634
View this thread: http://www.excelforum.com/showthread...hreadid=399104