Excel 2007 : Tricky prob with a error message

**Shagoir** · 12-20-2009, 08:03 PM

ok i have looked around the internet and these forums for a solution to this problem ...But havent found one anywhere..So i am hoping some techy can give me a pointer on how to solve it ..

I have a workbook that i use for sorting holidays fo employees..each sheet is a year claender that i put in letter for the reason they are not in ie H = Holiday or S = Sickness ...i have another sheet that counts everyones Holidays up so that no more than 3 peolpe can have the same day off ...So the prob is that i want a error message to pop up when im putting a H into a persons timesheet ...when the overall sheet reaches above 3 ..so i cant use validation as the cell thats going to tell me its over 3 isnt the one im using and also it calcs it self ...

Any ideas and if that doesnt make sence just say

i could even email anyone the workbook to have a look if that would help

thanx in advnace

also would like to make a log that records all activity inside the workbook

**teylyn** · 12-20-2009, 08:14 PM

Hi Shagoir,

welcome to the forum

so i cant use validation

You probably can, but it will be easier to help you if you could upload a small data sample. Specify the cell where you'd put in the H, and specify where you collect the information about the other employees' holidays.

You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

cheers