Dears,
im trying to make an excel sheet to organize the vacations of my small team, and i dont know how to do the following and i will be so happy of you could help me this time like what you always do
the sheet will be like below
1st column will include the whole days of the year and we can give a maximum number of 3 days as a vacation for each employee so i need a rule to allow each user to put letter (v) _stand for vacation_ only 3 times in his column per each month
if the employee tried to insert the (V) for the 4th time per month he should get an error
<tbody>
</tbody>1/10 v
2/10 v
3/10 v
4/10 v
5/10 v
6/10 v
2) i need to know how to enable excel cell range editing by certin user
Thanks for your support
im trying to make an excel sheet to organize the vacations of my small team, and i dont know how to do the following and i will be so happy of you could help me this time like what you always do
the sheet will be like below
1st column will include the whole days of the year and we can give a maximum number of 3 days as a vacation for each employee so i need a rule to allow each user to put letter (v) _stand for vacation_ only 3 times in his column per each month
if the employee tried to insert the (V) for the 4th time per month he should get an error
date | name1 | name2 | name3 |
<tbody>
</tbody>
2/10 v
3/10 v
4/10 v
5/10 v
6/10 v
2) i need to know how to enable excel cell range editing by certin user
Thanks for your support