Zod
09-22-2005, 01:32 AM
Hi!
I'm currently building a spreadsheet of staff sickness. It's very simple - It has a form which collects the data (Team Name, Staff Member, Return Date and Sickness info.) This data is then added to a worksheet called Data
Column A4 down contains - Team
Column B4 down contains - Staff Member
Column C4 down contains - Absent Date (Date that sickness is logged)
Column D4 down contains - Reason For Sickness
Column E4 down contains - Expected Return Date.
I have another worksheet called Stats which is hopefully going to hold some statistical info based on the data I collect. So far I have a list of teams and how many individuals are off from those teams, a total amount of staff off sick and the total number of current staff.
What I would like to do is count the amount of times an individual staff member goes off sick in the last six months and if it is more than three I would like to bring up a flag of some sort - Is this possible either in VBA or in excel?
Many thanks,
Zod.
I'm currently building a spreadsheet of staff sickness. It's very simple - It has a form which collects the data (Team Name, Staff Member, Return Date and Sickness info.) This data is then added to a worksheet called Data
Column A4 down contains - Team
Column B4 down contains - Staff Member
Column C4 down contains - Absent Date (Date that sickness is logged)
Column D4 down contains - Reason For Sickness
Column E4 down contains - Expected Return Date.
I have another worksheet called Stats which is hopefully going to hold some statistical info based on the data I collect. So far I have a list of teams and how many individuals are off from those teams, a total amount of staff off sick and the total number of current staff.
What I would like to do is count the amount of times an individual staff member goes off sick in the last six months and if it is more than three I would like to bring up a flag of some sort - Is this possible either in VBA or in excel?
Many thanks,
Zod.