Hi hope you can help. I have a table listing the attendance of workers.
Their attendance is logged using a series of codes, 1 for example
showing they turned up for work. There is another "PH" (public holiday
Leave which is inserted in their row if they take a PH leave day during
that month.

Each person has Ph Leave days allocatted and what I need to be able to
do is to be able to list down the dates someone takes a PH leave day in
their PH leave table, with each date listed below eachother.

Hope I have explained this ok and would appreciate all and any help.

don


--
opos
------------------------------------------------------------------------
opos's Profile: http://www.excelforum.com/member.php...o&userid=26260
View this thread: http://www.excelforum.com/showthread...hreadid=395557