Hi everyone,
I don't know if anyone can help me, but I'll give this forum a try.
I am trying to modify a template published by Chandoo since I think its look really neat:
Employee Vacation Tracker & Dashboard using MS Excel | Chandoo.org - Learn Microsoft Excel Online
Here the idea, we ask employee number 1 (oldest) to pick his vacancy choice, he then return us the document, we add it to the Table, and as more and more people send us their vacancy choice ( 1 by 1 ), a calendar update every time, and show if there is people overlap over each other, and if there are more than 3 people, so 4 people having the same day, a warning message, or a visual clue show up on a 1 years calendar.
Is it something that, of course, is do-able as there are 3 calendars view, if yes, may I get some help? I'm starting out with Excel, and it would be much more than appreciated.
I don't know if anyone can help me, but I'll give this forum a try.
I am trying to modify a template published by Chandoo since I think its look really neat:
Employee Vacation Tracker & Dashboard using MS Excel | Chandoo.org - Learn Microsoft Excel Online
Here the idea, we ask employee number 1 (oldest) to pick his vacancy choice, he then return us the document, we add it to the Table, and as more and more people send us their vacancy choice ( 1 by 1 ), a calendar update every time, and show if there is people overlap over each other, and if there are more than 3 people, so 4 people having the same day, a warning message, or a visual clue show up on a 1 years calendar.
Is it something that, of course, is do-able as there are 3 calendars view, if yes, may I get some help? I'm starting out with Excel, and it would be much more than appreciated.