H
Hartygan
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
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