|Total Annual Leave Days||5|
I'm hoping someone can help me please. I've done an excel spreadsheet for staff to put in their annual leave requests. However, I need a pop up box to appear if the total annual leave for any one week exceeds 15.
My SUM formula for total annual leave days starts on B40 and continues all the way through to BA40 and each column counts the annual leave days for that week.
I think this will need a macro and at the moment, that is a bit beyond my capabilities.
If anyone can help me I'd be very grateful and will provide any other information you need.