I know this might be a fuss so i'd like your help to at least start to the correct direction...
I keep notes for the leaves of a lot of people.
I have already created a drop list with all the names and 2 drop calendars in a sheet to select the person and the first and last day of his leave.

What i want to make is in another sheet, next to the list of names i have, a calendar with all the days of the year, on which the dates i selected (and all between ofcourse), to change color in the row of the person selected...
After finishing with the "first" person (probably with a button to run a code), it has to be available to do the same for another person, ofcourse without losing the data i have already printed for the first person.

In case someone wants to help and this is easy for him, i want to add other features too.
-Color will be "leave type dependent", (i.e. vacation, sickness, etc)
-To have a range as list, which will display who's absent everyday.
(And to spice it up, who will be absent for the next "3" days where "3" is
chosen from a drop list from 1 up to 7 i guess)

I know i ask too much, but it will save me from a lot of trouble.

Thanks

John