employee attendance tracker

[Ross]

I am using the 2009 employee attendance tracker from office online... of
course i have made some changes to suit my needs. This is the link to it for
better understanding:

http://office.microsoft.com/en-us/templates/TC103347271033.aspx?pid=CT101436151033

Now under the various categories like disability, essential, holiday etc, I
want to have a cap on them... For instance i can use the disability option
say only 7 times. After having it used for 7 times, if i try selecting that
option again, i want an error or a message to flash in front of my eyes that
i cant use the disability option any more as i have reached the max no. of
times allowed.

I already have a seperate column wherein the max leaves allowed under each
category is mentioned.

 

[Worn Out Retread]

I am using the 2009 employee attendance tracker from office online... of
course i have made some changes to suit my needs. This is the link to it
for
better understanding:

http://office.microsoft.com/en-us/templates/TC103347271033.aspx?pid=CT101436151033

Now under the various categories like disability, essential, holiday etc,
I
want to have a cap on them... For instance i can use the disability option
say only 7 times. After having it used for 7 times, if i try selecting
that
option again, i want an error or a message to flash in front of my eyes
that
i cant use the disability option any more as i have reached the max no. of
times allowed.

I already have a seperate column wherein the max leaves allowed under each
category is mentioned.

You could use Conditional Formatting to tell you when you have reached the
max for each category.