ok guys heres what i want to do.....
make it so i have a day to day router in excel, i then want to be able to put holidays into each week of the router (the router is a yearly one) with the holidays though i want it so that a limit is set for each week to only 2 different people, is this sounding confusin?
so basicaly i want to be able to log someones holiday into 1 of the weeks, i then want to log a holiday for someone else in the same week, i then want it so that if i try to add sombody else into the week, excel will notifiy me that i have people already added to the week, now is this possible? im sure it is but i just dont know how to do it,
if anyone can help i will be a very happy bunny as this is college work! thanks in advance!!